Tried a few ways at doing this but need help, using Lat and Long coordinates I would like to find the closest (lets just call for example) "well"



I have attached a sheet, the first tab needs to show the closest beside each location.

This shows two separate columns, one Lat and the other Long, then using the "well" tab, I would like to find the closest one to each Location.

Am sure there must be a way, I just cant get my head around it, have tried doing matches, Chooses, Lookup functions but not having much luck.


Any help would be greatly appreciated.

I have been advised to try the excel programming page from the other.
Thanks very much

Attached Files

Help.xlsx (20.6 KB, 11 views)