You use VLOOKUP when ____ of the lookup table contains the data you are looking up.
A) the first column
B) the last column
C) any column
D) all columns

Question

Quizplus · Accepted Answer

VLOOKUP searches for a certain value in the first column of a table and returns a corresponding value from a specified column in the same row as the search value. Therefore, the first column is the only correct choice for VLOOKUP to work properly.

You Use VLOOKUP When ____ of the Lookup Table Contains