Need Modified VLOOKUP()

[SDruley]

I learned that to solve many problems it is prudent to go further upstream in the logic and thinking. In this case, I re-engineered the lookup field and solved the problem.


By definition, in the VLOOKUP syntax, if range_lookup is either TRUE or is omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned...

Given this, my question is: is it possible that if an exact match is not found that the next smallest value is returned?

Thanks for any help

[teylyn]

Hi,

you may just need to shift your lookup table by one row.

Or, you can use INDEX/MATCH, with the last MATCH parameter set to -1, but your list must be sorted descending for that to work.

Upload an example and let's have a look.