software

Hi,

I know there are methods to find the closest match to a number that is
either greater than or smaller than a reference number but how do you
find the closest number regardless of whether its larger or smaller.

Any help would be very welcome.

Regards
Andy.--
andyiain
------------------------------------------------------------------------
andyiain's Profile: www.excelforum.com/member.php...foamp;userid=8335
View this thread: www.excelforum.com/showthread...hreadid=522640Assuming there are no duplicates in your list,
enter as an array formula
=SUMPRODUCT(((ABS(list-target))=MIN(ABS(list-target)))*list)
otherwise use this array formula for the first closest match
=INDEX(list,MATCH(MIN(ABS(list-target)),(ABS(list-target)),0))