View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BG
 
Posts: n/a
Default vlookup must return a value that is greater than

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.