How to use conditional on column?

[Brett]

I have a column with data such as:
$0
$1000
$5000
$7500

Say I hae $1500 in a cell and need to compare it with the values
above. I need the comparison to return the value that $1500 is
closest to but not more than. The returned value will be $5000.

I could do the above with nested if statements but that is messy. I
didn't find a CASE method in Excel that would allow me to keep
comparing values until the condition matched. Which method is best
for what I need to do?

Thanks,
Brett

 

[Dale Hymel]

A B
1 0 1000
2 1000 1500
3 5000 7500


10 1500 =VLOOKUP(A10,A1:B3,2)