Display name of closest location

[hawks12]

Hi all,

I am having trouble figuring out a way to display the smallest location name. I am comparing the lat/long for each location and want to display the location in the yellow bar at the top with the smallest valued location name. In my example below, 531 is the smallest value, so I want to display "Location 2" in the blue box area. Any ideas on how I could do this?


Capture.JPG

[ChemistB]

=INDEX($A$5:$A$9, MATCH(MIN(D$5:D$9), D$5:D$9,0))

assuming data in rows 5:9 and formula in D

[hawks12]

Thank you ChemistB! It worked great! Thanks!