Please enable JavaScript to view the comments powered by Disqus.


LOOKUP(...B2,D2:D7,E2:E7)

How to partial lookup for a number

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. 


Used Functions

Category: Lookup and reference

Looks up values in a vector or array

Syntax

LOOKUP(lookup_value, lookup_vector, [result_vector])

Lets chat on this