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 | First Point | ||
15 | Second Point | ||
16 | Diff Easting | ||
17 | Diff Nothing | ||
18 | Distance | ||
<tbody>
</tbody>
Hi,[/FONT]
[FONT="]
[/FONT]
[FONT="]Can help me on this question.[/FONT]
[FONT="]
[/FONT]
[FONT="]I'm trying to use vlookup to calculate the distance between two points. [/FONT]
[FONT="]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="]point in cell B15. The difference between eastings and northings of both slected point will be display in cell B16 and B17.[/FONT]
[FONT="]The distance between two points will be displayed in B18. Distance is =SQRT(B16^2+B17^2).[/FONT]