LOOKUP(...)
How to partial lookup for a number
Used Functions
Category: Lookup and reference
Looks up values in a vector or array
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
Practice LOOKUP Formula at Sheetzoom
LOOKUP formula at Microsoft help
0
The formula approximates the values to the largest number smaller then the given number to give an approximate match. We can change the bin range if we want to have the smaller number larger then the given number for getting a match.