I have been trying to do this various ways and can just not get it right.

I have a table that has multiple cities and populations and square miles:
A B C
1 city 1 sq mile 1 pop 1
2 city 2 sq mile 2 pop 2
3 city 3 sq mile 3 pop 3
4 city 4 sq mile 4 pop 4
5 city 5 sq mile 5 pop 5

I know how to order the list by (smallest to largest) number:

Square Miles Population
10 =large(b1:b5,5) =large(c1:c5,5)
11 =large(b1:b5,4) =large(c1:c5,4)

etc..

I would prefer to be able to display the name of the city (instead of the squre miles or population) that matches. I have tried some if... statements but I just can not get it right.

Any ideas?

Cliff Watson