vlookup surveying

[Marie81]

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


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.

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