Hello all:

Here's what I am trying to do. I enter a value into a A1 and then depending on what that value is, I want to return a multiplier. To make it simple, let's say my VLOOKUP table arrary is:

C D
0 0
2000 0.2
4000 0.35
6000 0.5
8000 0.65
10000 0.85
20000 1.0

Let's say I want to look up 3000 and I want it to return the higher value in the VLOOKUP, so 0.35 rather than 0.2. I know that if I do

VLOOKUP(A1,C1:D7,2,TRUE)
it will return the lower number. How do I get it to return the higher number?

Thanks for your help!

Will