Dear Friends,

I am trying to obtain the interpolated value from column B and return the
corresponding value from column A. There are two issues: I have repeated
numbers in column B which in this case I want the lowest value from column A
to be used and also as you can see the column A is between 0-1.8 and B is in
percentage.
For example 80% or 8% or 5% from column B corresponds to what values from
Column A.

Thanks for your help

A B
0.046875 100.00%
0.09375 100.00%
0.421875 99.60%
1.03125 99.60%
1.078125 22.40%
1.125 18.40%
1.171875 15.60%
1.21875 13.60%
1.265625 12.40%
1.3125 11.20%
1.359375 10.00%
1.40625 9.20%
1.453125 8.80%
1.5 8.00%
1.546875 7.20%
1.59375 6.80%
1.640625 6.40%
1.6875 6.00%
1.734375 5.60%
1.78125 5.20%
1.828125 4.80%