When creating a range for use with a type TRUE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.
A) descending
B) ascending
C) alphabetical
D) numerical

Question

Quizplus · Accepted Answer

The values in the first column of the table_array must be sorted in ascending order when creating a range for use with a type TRUE VLOOKUP table. This ensures that VLOOKUP can find an approximate match for the lookup value, which is necessary when using the TRUE argument. If the first column is not sorted, VLOOKUP may return incorrect or unexpected results.

When Creating a Range for Use with a Type TRUE