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, 9 views)

HI,

A suggestion. Get rid of the dup's in the sheet "Location". Then you may be able to use lookup. I have not tried. But......

HI,

Sorry for the quick post. But, even if you delete the dup's the "Lookup" will not work.
Just checked...

Bugger it, thanks for your quick response, I wasn't sure if this was possible, just going to have to do this the good old fashioned way with maps and a ruler app.

Thanks very much anyway

Cheers

Steve

See my reply to your separate thread: https://www.msofficeforums.com/excel...t-newpost.html
There's no programming required for this one.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]