Harold,

Assuming your table is sorted in ascending order based on its first column, then you could use this:

=IF(NOT(ISERROR(MATCH(C1,A1:A10,FALSE))),VLOOKUP(C 1,A1:B10,2),VLOOKUP(INDEX(A1:A10,MATCH(VLOOKUP(C1, A1:B10,1),A1:A10)+1),A1:B10,2))

with your table in A1:B10, and the value you want to base the lookup on in cell C1, to return the
value from the second column of your table.

HTH,
Bernie
MS Excel MVP


"Harold Good" wrote in message ...
Hi,

Is there any way that I can get vlookup or an equivalent to use the next value that is GREATER
than the lookup value? I'm not sure why it assumes we always want the value that is LESS than the
lookup value.

If not, any suggested workarounds?

Thanks,

Harold