I have three columns of information:

RATE 15 DAY 30 DAY
5.750% 0.375 0.500
5.875% -0.250 -0.125
6.000% -0.625 -0.500
6.125% -1.125 -1.000
6.250% -1.500 -1.375
6.375% -1.875 -1.750
6.500% -2.250 -2.125
6.625% -2.750 -2.625
6.750% -3.125 -3.000
6.875% -3.625 -3.500

I three columns are the result of formulas which find the data elsewhere
(albeit simple references, i.e. =R3).

I would like to find the price in the third column closest, but never
greater than zero. and return this as my first result. The second result is
the corresponding interest rate (from the first column) that goes with the
matched price.

I've tried VLOOKUP, but I can't sort the third column another way and I keep
getting -3.50 as my matched price.

Other suggestions for how to do this? I would really appreciate it.

Karen