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.