Thread
:
vlookup must return a value that is greater than
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
vlookup must return a value that is greater than
Sort your lookup data on col A descending
=INDEX(C1:C3,MATCH(9,A1:A3,-1))
HTH
--
AP
"BG" a écrit dans le message de news:
...
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.
Reply With Quote