Vlookup

[Marie81]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Point[/TD]
[TD]Eastings[/TD]
[TD]Northings[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]567768[/TD]
[TD]6376890[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]567702[/TD]
[TD]6376035[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]567835[/TD]
[TD]6377836[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]567936[/TD]
[TD]6376471[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD]568035[/TD]
[TD]6376044[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6[/TD]
[TD]566834[/TD]
[TD]6377837[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7[/TD]
[TD]567413[/TD]
[TD]6378635[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8[/TD]
[TD]566036[/TD]
[TD]6378999[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9[/TD]
[TD]568634[/TD]
[TD]6377941[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]10[/TD]
[TD]566345[/TD]
[TD]6376534[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD]First Point[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD]Second Point[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD]Diff Easting[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD]Diff Nothing[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD]Distance[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[FONT=&quot]
Hi,[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Can help me on this question.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I'm trying to use vlookup to calculate the distance between two points. [/FONT]
[FONT=&quot]I need to be able to choose any point I wish and type that into cell B14 (starting point). Then the same thing for the end [/FONT]
[FONT=&quot]point in cell B15. The difference between eastings and northings of both slected point will be display in cell B16 and B17.[/FONT]
[FONT=&quot]The distance between two points will be displayed in B18. Distance is =SQRT(B16^2+B17^2).[/FONT]

 

[James006]

Hello,

If I understand correctly ...

in cell B16 =VLOOKUP(B15,$A$2:$C$11,2)-VLOOKUP(B14,$A$2:$C$11,2)

in cell B17 =VLOOKUP(B15,$A$2:$C$11,3)-VLOOKUP(B14,$A$2:$C$11,3)

HTH

 

[L. Howard]

Does this work correctly?

Howard

Excel 2012
	A	B	C
1	Point	Eastings	Northings
2	1	567768	6376890
3	2	567702	6376035
4	3	567835	6377836
5	4	567936	6376471
6	5	568035	6376044
7	6	566834	6377837
8	7	567413	6378635
9	8	566036	6378999
10	9	568634	6377941
11	10	566345	6376534
12
13
14		10	First Point
15		1	Second Point
16		-1423	Diff Easting
17		-356	Diff Nothing
18		1466.85548	Distance
Sheet1

Cell Formulas
Range	Formula
B16	=VLOOKUP(B14,$A$2:$B$11,2,0)-VLOOKUP(B15,$A$2:$B$11,2,0)
B17	=VLOOKUP(B14,$A$2:$C$11,3,0)-VLOOKUP(B15,$A$2:$C$11,3,0)
B18	=SQRT(B16^2+B17^2)

 

[Marie81]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Point[/TD]
[TD]Eastings[/TD]
[TD]Northings[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]567768[/TD]
[TD]6376890[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]567702[/TD]
[TD]6376035[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]567835[/TD]
[TD]6377836[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4[/TD]
[TD]567936[/TD]
[TD]6376471[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]5[/TD]
[TD]568035[/TD]
[TD]6376044[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]6[/TD]
[TD]566834[/TD]
[TD]6377837[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]7[/TD]
[TD]567413[/TD]
[TD]6378635[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]8[/TD]
[TD]566036[/TD]
[TD]6378999[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9[/TD]
[TD]568634[/TD]
[TD]6377941[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]10[/TD]
[TD]566345[/TD]
[TD]6376534[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD]First Point[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD]Second Point[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD]Diff Easting[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD]Diff Nothing[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD]Distance[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi,


Can help me on this question.


I'm trying to use vlookup to calculate the distance between two points.
I need to be able to choose any point I wish and type that into cell B14 (starting point). Then the same thing for the end
point in cell B15. The difference between eastings and northings of both slected point will be display in cell B16 and B17.
The distance between two points will be displayed in B18. Distance is =SQRT(B16^2+B17^2).

*What should I put in cell B14 and B15, it still give #VALUE !

 

[James006]

Your question ...

What should I put in cell B14 and B15

In your first message ...

I need to be able to choose any point I wish and type that into cell B14 (starting point). Then the same thing for the end
point in cell B15