What is the function of the VLOOKUP function in Excel?
ATo perform a horizontal lookup and return a value based on a specified criteria
BTo find the average of a range of cells
CTo add up a range of cells
DTo perform a vertical lookup and return a value based on a specified criteria
Correct answer
D. To perform a vertical lookup and return a value based on a specified criteria
Explanation
To perform a vertical lookup and return a value based on a specified criteria is the correct answer. Review the question and compare it with the other choices to remember this fact for future exams.