"Max" wrote...
Nice one, Frank !
....
"Frank Kabel" wrote in message
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))

If this were original, perhaps the fawning wouldn't be quite so nauseating,
but this one is older than the hills. For example,

http://groups.google.com/groups?selm...c7%40defau lt