match to closest value in a table to return second column value

[Liz_I3]

HI
I am trying to lookup a value in cell E6 in a table to the closest match. But I want to return the value in the second column of the table.

Table
99.99% A
50.00% B
25.00% C


if cell E6 = 65.00% I want cell D6 to show B

this formula =INDEX(A1:A3,MATCH(MIN(ABS(A1:A3-E6)),ABS(A1:A3
-E6),0),1) will return 50.00%, but how do I alter it to get B

Thnaks
L

 

[hatman]

=index(b1:b3,match(min(abs(a1:a3-e6)),abs(a1:a3
-e6),0),1)

 

[Liz_I3]

Thank you very much That did exactly what I wanted

you are brilliant

L