I'd be tempted to go for a user defined function here which takes the
coordinates from the target sheet as two of its arguments and the range
containing the set on the reference sheet as a third.

The function would calculate the individual distances one by one,
kepping track of the minimum. At the end of this, the min value would
be tested against the 50 figure and the appropriate value returned.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=550152