Vlookup

D

Doron Klein

I want to use the vlookup function, but instead of find the equal or
small value that close to the lookup_value. I want to find the equal
or big value that close to the lookup_value.

Thank you.

Doron
 
B

Biff

Hi!

If you sort descending the lookup table you can use a
combo index/match with a match_type argument of -1. See
Excel help on the match function for a description.

Biff
 
Top