For lookup functions to work properly,the data in the table array must be sorted ________.
A)by color
B)in reverse alphabetic order
C)in descending order
D)in ascending order

Question

Quizplus · Accepted Answer

Lookup functions such as VLOOKUP and HLOOKUP require the data in the table array to be sorted in ascending order to work properly. This is because these functions search for the values in the leftmost column of the table array and the values in this column must be in ascending order for the function to return accurate results.

For Lookup Functions to Work Properly,the Data in the Table