The VLOOKUP function compares a lookup value to the first column of a lookup table, and returns the corresponding value in ____ column of the lookup table.
A) a designated
B) the first
C) the second
D) the last

Question

Quizplus · Accepted Answer

The VLOOKUP function requires the user to specify which column of the lookup table contains the value to be returned, which is referred to as the "designated" column.

The VLOOKUP Function Compares a Lookup Value to the First