What is the function of the VLOOKUP function in Excel?
- A. To perform a vertical lookup and return a value based on a specified criteria
- B. To perform a horizontal lookup and return a value based on a specified criteria
- C. To add up a range of cells
- D. To find the average of a range of cells
Explanation
VLOOKUP searches vertically down the first column of a table and returns a related value from a specified column in the same row. HLOOKUP performs the corresponding horizontal search.