vlookup must return a value that is greater than
What if that relative is an exact match or the last one?
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"Pete_UK" wrote in message
oups.com...
If you use MATCH( ) then you will get the (relative) position in the
range - you can add 1 onto this and feed this into an INDEX( ) function
to get what you want.
Hope this helps.
Pete
|