"Roccobarocco" wrote
What if it is NOT sorted in ascending order?

Just in case you did not receive,
Frank has posted the suggestion below ..

"Frank Kabel" wrote

Hi
for the closest value in an unsorted list use the following array
formula (entered with CTRL+SHIFT+ENTER):
=INDEX(A1:A5,MATCH(MIN(ABS(A1:A5-C1)),ABS(A1:A5-C1),0))

--
Regards
Frank Kabel
Frankfurt, Germany

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----