Hi Everyone,

I have done a search on the forum and found some threads but no solution.

Below is the data I have in the second tab of my worksheet.

On the first tab I want to be able to enter any site code and I want the result of of the 5 nearest sites returned ?

Any ideas ?


SITE CODE Latitude Longitude
M338 -22.605430 39.040540
M298 -32.923340 19.422780
M361 -22.105120 29.121320
M330 -32.571310 29.811520
M002 -22.857130 39.027990
M357 -24.746350 29.190740
M384 -32.023860 39.909320
M236 -24.745033 29.203142
M090 -24.769882 29.089913

Thanks,