Home » Posts

Lookup value between two numbers

To lookup values between two values and return a corresponding result, you can use the LOOKUP function and a sorted table. In the example shown, the formula in C5 is: =LOOKUP(B5,mins,results) where "mins" is the named range E5:E9, and "results" is the named range G5:G9.

April 14, 2025 · 1 min · 43 words · Ronald Rivas

This is because when LOOKUP can’t find a match, it will match the next smallest value.

In case of duplicates, this formula will return the last match.Explanation of logic is here.

LOOKUP’s default behavior makes it useful for solving certain problems in Excel.

Excel formula: Group numbers with VLOOKUP

Excel formula: Find closest match

Excel formula: Lookup number plus or minus N

Excel LOOKUP function