Finding the Hypotenuse of from two pairs of X,Y Coordinates

**LordAcoustic** · 02-04-2010, 11:06 AM

Hello All,

I have a map with several waypoints and would like to find the distance between any of these two waypoints. Sounds simple, but I have having an issue with the later parts of the excel file. Let me explain further.

There are over 100 waypoints on this map we have. Each waypoint has an, seemingly arbitrary, X-coordinate and Y-Coordinate. However, if you divide the coordinates by [X], they turn into miles. It should go without saying that finding the distance between two waypoints is rather simple mathematically, but I having an issue figuring out how to pull two random waypoints and having the distance automatically calculated.

So far, I just have column A with the waypoint name and with column B and C having the X and Y coordinates respectively. Is there anyway I can create some sort of call function that when two waypoint values are entered it would automatically calculate the distances?

**zbor** · 02-04-2010, 11:12 AM

Can you upload example workbook with desired inputs and outputs?

Basically, you can do that with VLOOKUP I guess.

**rwgrietveld** · 02-04-2010, 11:21 AM

Play with F2, F3

I used VLOOKUP and data validation

**LordAcoustic** · 02-04-2010, 11:35 AM

Originally Posted by rwgrietveld

Play with F2, F3

I used VLOOKUP and data validation

I think that will work perfectly... my only question is that if I add addition waypoitns (since there are over 100) will that F2 and F3 continue to add all of the additional waypoints?