How to sort a table based on values in another table?

[Mr. Snrub]

Suppose I have the following two tables (formatted as Excel tables):

StateData:

State Abbreviation	State Name	Population
AL	Alabama	4,903,185
AK	Alaska	710,249
AZ	Arizona	7,278,717
AR	Arkansas	3,017,804

PresidentData:

LastName	Birthplace (State Abbreviation)
Trump	NY
Obama	HI
Bush	CT

How do I sort the PresidentData table by the population of the state in which they were born?

 

[CA_Punit]

is this what you want

Book1
	A	B	C	D	E	F
1	State Abbreviation	State Name	Population
2	NY	Alabama	4,903,185
3	HI	Alaska	710,249
4	CT	Arizona	7,278,717
5	AR	Arkansas	3,017,804
6
7					Sorted Data
8	LastName	Birthplace (State Abbreviation)			LastName	Birthplace (State Abbreviation)
9	Trump	NY			Bush	CT
10	Obama	HI			Trump	NY
11	Bush	CT			Obama	HI
12
13
Sheet3

Cell Formulas
Range	Formula
E9:F11	E9	=+INDEX($A$9:$B$11,MATCH(SMALL(RANK(VLOOKUP($B$9:$B$11,$A$2:$C$5,3,0),$C$2:$C$5,0),{1;2;3}),RANK(VLOOKUP($B$9:$B$11,$A$2:$C$5,3,0),$C$2:$C$5,0),0),{1,2})
Dynamic array formulas.

so this should work with ctrl+shift+enter. However if it doesn't then check for this first VLOOKUP($B$9:$B$11,$A$2:$C$5,3,0),$C$2:$C$5,0),{1;2;3})

 

[Mr. Snrub]

Well, I don't want to have to create an entirely new table and duplicate all that data. I was hoping to just go to Data --> Sort and do something there.

 

[CA_Punit]

Then I guess you have lookup the population from the population table first and then sort population Z-A