software

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.046875100.00%
0.09375100.00%
0.42187599.60%
1.0312599.60%
1.07812522.40%
1.12518.40%
1.17187515.60%
1.2187513.60%
1.26562512.40%
1.312511.20%
1.35937510.00%
1.406259.20%
1.4531258.80%
1.58.00%
1.5468757.20%
1.593756.80%
1.6406256.40%
1.68756.00%
1.7343755.60%
1.781255.20%
1.8281254.80%