GEO-Fencing Formula

[usef]

Hello,

i have a spreadsheet with coordinates in column B and C, and pre defined landmarks coordinates in a table located from L1:N50 headers ("Lat", "long", "Landmark name")

what im trying to do is have a formula in column D to do something similar to a vlookup to the landmark table. This should return the name of the landmark of the location if within 100 meters of the landmark in any direction (circle).

Examples:

landmark table
L M N
24.47423167 54.32243833 Marina Mall

location sample
B C D
24.4203666 54.479036 False
24.4745575 54.323085 Marina Mall
24.4698849 54.322435 False


TIA

 

[hugoexl]

Shg,

I used the formula that you provided, but I am getting a VALUE error. I even recreated the example table that you provided and got the same results. Any idea why this may be happening. I think the error has to do with the MIN section of the formula. I am using Excel for Mac. Any help or insights you could provide would be greatly appreciated.

Thank you

hugoexl