Finding the closest value

[Hitch75]

Let's say we have the following numbers in cells A1, B1, C1...:
3 5 12 16 22

In F1, the given value is 10.

In G1, I need a formula which will pick the closest match to the given number 10 (in this case it would be 12).

Thanks!

[shg]

=INDEX(A1:E1, MATCH(MIN(ABS(A1:E1-F1)), ABS(A1:E1-F1), 0))

The formula MUST be confirmed with Ctrl+Shift+Enter.

[Hitch75]

Thanx!! It works.