The LOOKUP function uses a ____ lookup type, so the column or row containing the lookup values must be in ascending order.
A) TRUE
B) FALSE
C) both a and b
D) neither a nor b

Question

Quizplus · Accepted Answer

The LOOKUP function uses an approximate lookup type, which requires that the column or row containing the lookup values be in ascending order. If the values are not in ascending order, the function may return incorrect results. Therefore, option A is the correct answer.

The LOOKUP Function Uses a ____ Lookup Type, So the Column