Back again,



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.

Thanks very much

Steve

Attached Files

Help.xlsx (20.6 KB, 105 views)