VLOOKUP and the like return the next lowest value when the exact
search value cannot be found. I need to be able to return the next
highest value. For example, I want to return 112000 when I search the
following table for the value 760 (in cell A2, say):

B C
75 20000
150 37000
300 60000
450 76000
600 87000
750 94000
1250 112000

=vlookup(a2,b1:c7,2) finds 750 and returns 94000 ... I need it to find
1250 and return 112000.