display cell value based on value in a range

[sinski]

Hello,

I am trying to figure out a formula that will display the value of a cell based on the value in a range of cells. For example, I have 4 cities with sales by month. I want to display the top 2 cities each month below the range of values for those months.

Month1 Month2 Month3 Month4
Milwaukee 5 4 5 6
Chicago 3 6 3 3
Tempe 2 7 2 7
New York 1 8 6 2

Top City Milwaukee New York New York Tempe
2nd Top City Chicago Tempe Milwaukee Milwaukee

The attached file show the higlighted cells that I would like as formulas

[mrice]

In B7

=INDEX($A$2:$A$5,MATCH(LARGE(B$2:B$5,1),B$2:B$5,0))

in B8

=INDEX($A$2:$A$5,MATCH(LARGE(B$2:B$5,2),B$2:B$5,0))

and copy across.

[sinski]

Thanks. That worked!