I have a list of a number of locations and their corresponding Longitude and Latitude.
I need to be able to enter current Longitude and Latitude from a GPS unit into a form and give back the closest location from the Excel table (nearest match by distance for both Long and Lat)
One of the tricks gets to be if for example the desired longitudes are similar for multiple locations but the latitudes are different.
However I have no idea where to start. I was thinking of trying to calculate actual distance from desired location to each of the locations in the list (not even really sure how to convert long/lat to feet) but that didn't seem as efficient.
Is there a way to do this with Index/Match or an array formula or something?
Does anyone have any ideas?
I need to be able to enter current Longitude and Latitude from a GPS unit into a form and give back the closest location from the Excel table (nearest match by distance for both Long and Lat)
One of the tricks gets to be if for example the desired longitudes are similar for multiple locations but the latitudes are different.
However I have no idea where to start. I was thinking of trying to calculate actual distance from desired location to each of the locations in the list (not even really sure how to convert long/lat to feet) but that didn't seem as efficient.
Is there a way to do this with Index/Match or an array formula or something?
Does anyone have any ideas?