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

I think the last argument shuld be "true"---see help <vlookp


Doron Klein wrote in message
om...
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

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

-----Original Message-----
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
.