Hope someone can help: I’ve searched but can’t find a similar question so apologies in advance for repetition. This seems REALLY simple but I’m failing miserably!

Basically I’m designing a spreadsheet to track the performance of a customer’s network against a service level agreement. I’m trialling it with 50 sites although it’ll be over 500 in total…. In column A (A2:A52) the names of the sites are listed. In column D (D2:D52) the site availability is listed.

I can find the lowest number fine by using =MIN(D2:D52) but can I add something into a cell which will report the site from column A that the lowest number corresponds to?

At a very basic level it’ll look something like this (but with straight columns!):

¦ A ¦ D ¦
1¦ Site ¦ Availability ¦
2¦ London ¦ 99.50 ¦
3¦ Paris ¦ 99.80 ¦
4¦ New York ¦ 99.90 ¦
5¦ Lowest Avail ¦ 99.50 ¦ - Calculated using =MIN(D2:D4)
6¦ Lowest Site ¦ London ¦ - What would I use to get this automatically?

Any help would be appreciated!