Trying to match sort Sheet2 verse sheet1

[zone709]

Hi i need to sort sheet2 rows by Id number in column D from Sheet1 order. So whatever order sheet1 is in by id number I need sheet2 to look the same. The reason why I cant sort sheet1 id numbers by numbers then sheet2 is because. The order that Sheet1 is in I need it in the same order on sheet2 whole row.

Sheet1

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​
1​	ORG UNIT	LAST NAME	FIRST NAME	ID
2​				39
3​				149
4​				26
5​				10
6​				30
7​			Frank	29
8​			frank	29
9​			kenny	62
10​				6
11​				6
12​			john	7
13​			john	7
14​				11
15​				11
16​				1
17​				1
18​				14
19​				14
20​				4
21​				4
22​				3
23​				3

Sheet: Sheet1

Now need sheet2 to look the same. Which you can see its not. If the numbers are the same its fine as long as it sorts the whole row by number to be exact from sheet1. Any help would be great.

Sheet2

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​
1​	ORG UNIT	LAST NAME	FIRST NAME	ID
2​			frank	29​
3​			frank	29​
4​			kenny	62​
5​			john	7​
6​			john	7​
7​				6​
8​				6​
9​				11​
10​				11​
11​				14​
12​				14​
13​				1​
14​				1​
15​				3​
16​				3​
17​				4​
18​				4​
19​				30​
20​				10​
21​				39​
22​				149​
23​				26​

Sheet: Sheet2

 

[Fluff]

You could put this in col E of sheet 2
=MATCH(D2,sheet1!D$2:D$23,0)

and then sort on that

 

[zone709]

You could put this in col E of sheet 2
=MATCH(D2,sheet1!D$2:D$23,0)

and then sort on that

Thanks for the reply. Left my computer at the moment will try this later.

 

[zone709]

Hi so this didn't work it was pulling from a different line and not returning the right numbers. I am trying to sort the whole row on sheet2 to match sheet1 the number order that sheet1 has in Column D. The match formula pulls in some random numbers.

 

[Fluff]

Using your data I get

Excel 2013/2016
	A	B	C	D	E
1	ORG UNIT	LAST NAME	FIRST NAME	ID
2			frank	29	6
3			frank	29	6
4			kenny	62	8
5			john	7	11
6			john	7	11
7				6	9
8				6	9
9				11	13
10				11	13
11				14	17
12				14	17
13				1	15
14				1	15
15				3	21
16				3	21
17				4	19
18				4	19
19				30	5
20				10	4
21				39	1
22				149	2
23				26	3
Sheet2

Cell Formulas
Range	Formula
E2	=MATCH(D2,Sheet1!D$2:D$23,0)

Which when sorted becomes

Excel 2013/2016
	A	B	C	D	E
1	ORG UNIT	LAST NAME	FIRST NAME	ID
2				39	1
3				149	2
4				26	3
5				10	4
6				30	5
7			frank	29	6
8			frank	29	6
9			kenny	62	8
10				6	9
11				6	9
12			john	7	11
13			john	7	11
14				11	13
15				11	13
16				1	15
17				1	15
18				14	17
19				14	17
20				4	19
21				4	19
22				3	21
23				3	21
Sheet2

 

[zone709]

ok i got it. I wasnt understanding how it was working. Thats my fault now i understand and get it. I build this into a small macro, but i have to fix something now so it can work off of this. May start a new post or come back thanks alot

 

[Fluff]

Glad it's working & thanks for the feedback