Vlookup next largest value

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

or sort descending (on col c)
then
=INDEX(C1:D7,MATCH(A1,C1:C7,-1),2)

That gets me on the right track, but it doesn't quite do what I need it to. If I pick a number in the list (say 4000) I need the formula to return the normal VLOOKUP value. It's just when my lookup value is between the numbers in the list that I need it to jump up.

the example i posted works.

Try

=INDEX(D1:D7,MATCH(A1,C1:C7)+(LOOKUP(A1,C1:C7)<>A1))

Thank you everyone for your help! I got daddylonglegs' to work perfectly. Martindwilson, I didn't try yours because I did daddylonglegs' first but Iam sure it would have worked too, thanks for the help. NBVC, I did do the Shift+Ctrl+Enter thing and it worked but not when the lookup value was exactly matched in the list, it still returned the higher number.

Thanks again!