find a way to show a closest to using lat and long cordinates
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
|