vlookup must return a value that is greater than

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a value is not found in a range, I would like it to return the smallest
value greater than itself.


A B C
i.e. 8 2
10 4
12 6

By default if I searched for 9, and needed the info from column C, I would 2
as my result, but instead I would like to get 4 as the result.
 
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
 
What if that relative is an exact match or the last one?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Back
Top