When setting up a Vlookup table in Excel, the number in the far left column is the value when ?

Question

a) You stop returning a value in this row.

b) You start returning a value in this row.

c) You start returning a value in this column.

d) It has nothing to do with what values you return.

Answer 1

The correct answer is:

b) You start returning a value in this row.

In a VLOOKUP function, the number (or value) in the far left column of the lookup table is the value that you are searching for, and the function will return the corresponding value from the row in which that search value is found.