Try:

=INDEX($AI$1:$CY$1,1,MATCH(MIN($AI2:$CY2),$AI2:$CY 2,0))

You can substitute MIN($AI2:$CY2) with cell which contains this value

HTH

"Patricia" wrote:

I have a mileage table exported out of Map Point and into Excel. I have a
formula to return the minimum mileage but I also need to return the city in
the column next to the formula. I'd also like to find the next closest city.
Any help will be appreciated.

Min Formula - =MIN(AI2:CY2)

Columns look like:
Closest Min Dist Amusement Chicago Cincinnati Cleveland
Springfield
2 Field Museum 2 200
400 150
xx Six Flags, Gurney xx xxx
xxx xxx
xxx Six Flags, St. Louis xx xxx
xxx xxx