To use the VLOOKUP function, where should the lookup value be located in a table?

VLOOKUP searches for the lookup value in the leftmost, or first, column of the table. It then returns a value from another column in the matching row. So the correct choice is “the first column.”

AI-written and checked against the verified answer.