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!