The condition that VLOOKUP assumes is that
A)there are no nonzero values in the range.
B)all the arguments are of the same dimension.
C)the first column of the table is sorted in ascending order.
D)the columns with empty cells are to be neglected.

Question

Quizplus · Accepted Answer

VLOOKUP assumes that the first column of the table is sorted in ascending order. If the first column is not sorted, the function may return incorrect results or an error. Therefore, it is always best to ensure that the first column is sorted before using VLOOKUP.

The Condition That VLOOKUP Assumes Is That