lookup tables

R

Richard D

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

I want to find the next LARGEST value in a table that I have sorted. Is this
possible?
 
A

Aladin Akyurek

Richard said:
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

I want to find the next LARGEST value in a table that I have sorted. Is this
possible?
Click to expand...

Looks like...

=INDEX(ReturnRange,MATCH(LookupValue,MatchRange,1)+(LOOKUP(LookupValue,MatchRange)<>LookupValue))
 
Top