Vlookup distance

[Marie81]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Location[/TD]
[TD]Easting[/TD]
[TD]Northing[/TD]
[TD]Distance[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]WAS001[/TD]
[TD]391428[/TD]
[TD]6470346[/TD]
[TD]8717.121[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]WAS002[/TD]
[TD]400141[/TD]
[TD]6470614[/TD]
[TD]0.000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]WAS003[/TD]
[TD]402232[/TD]
[TD]6464061[/TD]
[TD]6878.524[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]WAS004[/TD]
[TD]394873[/TD]
[TD]6474455[/TD]
[TD]6461.184[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]WAS005[/TD]
[TD]393893[/TD]
[TD]6464097[/TD]
[TD]9028.222[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Surveyor location[/TD]
[TD]WAS001[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Closest SSM[/TD]
[TD]WAS003[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Distance[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi,

Can help on this. Lets say surveyor location is at WAS001, and the closest control point (SSM) is at WAS003. I'm trying to get the minimum distance between the surveyor and the closest SSM using vlookup. Any help on this for the formula.

Thank you.

 

[FinPro]

Hello,

What does column C, D and E stands for and how they relate to this problem?

 

[Marie81]

C and D column is use for to find the distance between the location.

From WAS 002 to WAS 001 = SQRT((400141 - 391428)^2) + (6470614 - 6470346)^2))

 

[AlanY]

try

Excel 2012
	B	C	D	E	F
1		Location	Easting	Northing	Distance
2	1	WAS001	391428	6470346	8717.121
3	2	WAS002	400141	6470614	0
4	3	WAS003	402232	6464061	6878.524
5	4	WAS004	394873	6474455	6461.184
6	5	WAS005	393893	6464097	9028.222
7
8
9		Surveyor location	WAS001
10		Closest SSM	WAS003
11		Distance	12499.11
Sheet3

Cell Formulas
Range	Formula
D11	=((VLOOKUP(D9,$C$2:$F$6,2,0)-VLOOKUP(D10,$C$2:$F$6,2,0))^2+(VLOOKUP(D9,$C$2:$F$6,3,0)-VLOOKUP(D10,$C$2:$F$6,3,0))^2)^0.5

 

[FinPro]

If Surveyor location and SSM will be specified, then following should work:

=VLOOKUP(C9,B2:E6,4) - VLOOKUP(C10,B2:E6,4)

Is this what you are looking for?

 

[Marie81]

If Surveyor location and SSM will be specified, then following should work:

=VLOOKUP(C9,B2:E6,4) - VLOOKUP(C10,B2:E6,4)

Is this what you are looking for?

I got it already, Thanks.