Even if the compare values are not arranged in order Excel can still retrieve the correct results from a lookup table.

Question

Quizplus · Accepted Answer

Excel's VLOOKUP and HLOOKUP functions require the lookup column or row to be sorted in ascending order to correctly find a match when the range_lookup argument is set to TRUE (approximate match). If the data is not sorted, these functions may return incorrect results.

Even If the Compare Values Are Not Arranged in Order