You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

Question

Quizplus · Accepted Answer

This is true. The LOOKUP function can be used with an array to find an exact match or the next smallest or largest value, and it can work in any direction (not just vertically or horizontally like VLOOKUP or HLOOKUP). When the lookup type argument is omitted, it defaults to TRUE (or 1), which means it will find the nearest match that is less than or equal to the lookup value.

You Can Often Use a LOOKUP Function Instead of a VLOOKUP