Find Closet Match in a table

Hi everyone,

I was wondering if someone could help me with a basic problem. I have a table that I am trying to find the closest match and return that value.

728 -8.1
791 -4.7
698 -9.6
700 -10.3
806 -2.5
810 -9.2

So if I had a search value of 730 then the result would be -8.1.

Many thanks,

Matt

Need to add if the search value is +/-20 outside the values in Column A then the result = 0,

ie 708 = 0
710 = -8.1
820 = -9.2
830 = 0


Thanks

With your data in cells A2:B7 and the search value (730) in C1 I used this formula:

=INDEX(B:B,MAX(INDEX(ROW($A$2:$A$7)*(ABS($A$2:$A$7-C2)=MIN(INDEX(ABS($A$2:$A$7-C2),0))),)))