What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)
A) number of the column containing the return value
B) location of the lookup table
C) whether to return a value only when an exact match is found
D) cell with the lookup value

Question

Quizplus · Accepted Answer

The third argument (3) refers to the number of the column containing the return value. In this case, the formula is looking up the value 10005 in the range A1:C6 and will return the value in the third column of that range.

What Does the Third Argument (3) Refer to in the Following