vlookup surveying

[Marie81]

Location (SSM)	Easting	Nothing
WAS 001	391428	6470346
WAS 002	400141	6470614
WAS 003	402232	6464061
WAS 004	394873	6474355
WAS 005	393893	6464097
WAS 006	396395	6468007
WAS 007	394026	6467774
WAS 008	396126	6472008
WAS 009	398779	6469584
WAS 010	390263	6464358
WAS 011	396514	6461943
WAS 012	398355	6465536
WAS 013	388091	6467173
WAS 014	402582	6466305
WAS 015	393924	6458361
WAS 016	392549	6472449
WAS 017	396136	6459788
WAS 018	388528	6465303
WAS 019	392105	6468441
WAS 020	392324	6461243

<tbody>
</tbody>

Hi everyone,

Can help for the above data. Your senior surveyor has asked you to write an excel program that will determine the closest SSM that the company has in its database to the location where any of the surveyors in the company working. From the list in the spreadsheet above, you are to:

1) input the location of the surveyor
2) determine the closest SSM
3) output the distance to the SSM from the location of the surveyor
(distance =SQRT(DiffEasting^2 - DiffNorthing^2)

 

[arthurbr]

Homework?

 

[Marie81]

*Yep homework, tried to work it out but can't seem to get it.

Location (SSM)	Easting	Northing	Distance		Surveyor Location	WAS 019
WAS 001	391428	6470346	8717.121
WAS 002	400141	6470614	0.000
WAS 003	402232	6464061	6878.524
WAS 004	394873	6474355	6461.184		Closest SSM	WAS 015
WAS 005	393893	6464097	9028.222
WAS 006	396395	6468007	4563.876
WAS 007	394026	6467774	6742.316
WAS 008	396126	6472008	4250.113		Distance	#VALUE!
WAS 009	398779	6469584	1707.614
WAS 010	390263	6464358	11692.409
WAS 011	396514	6461943	9399.009
WAS 012	398355	6465536	5382.925
WAS 013	388091	6467173	12531.679
WAS 014	402582	6466305	4952.369
WAS 015	393924	6458361	13739.982
WAS 016	392549	6472449	7810.614
WAS 017	396136	6459788	11543.063
WAS 018	388528	6465303	12769.827
WAS 019	392105	6468441	8324.616
WAS 020	392324	6461243	12203.325

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>