Filter Differences between 2 Tables

[uk747]

Have 2 Tables. One on Sheet1 and Sheet2

Some people may appear in a Table but not in the other that's fine. What I need is to Filter and Just show where a person appears in both Tables but there Salary is different in one of the Tables

e.g. in Eg Below Result should be

Alan because he is 24000 in Table 1 and 24500 in Table 2 and Mike as he is 23550 in Table 1 but 23560 in Table 2

and would like result as below:-
Name Salary1 Salary2
Alan 24000 24500
Mike 23550 23560


Sheet1 Table

Name	Random Stuff	Random Stuff	Random Stuff	Salary
Fred	x	x	x	20250​
Bob	x	x	x	30000​
Alan	x	x	x	24000​
Dave	x	x	x	27000​
Gemma	x	x	x	26000​
Mike	x	x	x	23550​
Ben	x	x	x	28750​
Arthur	x	x	x	54500​

Sheet2 Table

Name	Random Stuff	Random Stuff	Random Stuff	Salary
Fred	x	x	x	20250​
Bob	x	x	x	30000​
Alan	x	x	x	24500​
Dave	x	x	x	27000​
Gemma	x	x	x	26000​
Mike	x	x	x	23560​
Ben	x	x	x	28750​
Mary	x	x	x	32400​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Name	Random Stuff	Random Stuff	Random Stuff	Salary
2	Fred	x	x	x	20250
3	Bob	x	x	x	30000
4	Alan	x	x	x	24000
5	Ben	x	x	x	27000			Alan	24000	24500
6	Gemma	x	x	x	26000			Mike	23550	23560
7	Mike	x	x	x	23550			Dave	28750	27000
8	Dave	x	x	x	28750
9	Arthur	x	x	x	54500
10
11
12
13
14
15
16
17
18
19
20	Name	Random Stuff	Random Stuff	Random Stuff	Salary
21	Fred	x	x	x	20250
22	Bob	x	x	x	30000
23	Alan	x	x	x	24500
24	Dave	x	x	x	27000
25	Gemma	x	x	x	26000
26	Mike	x	x	x	23560
27	Ben	x	x	x	27000
28	Mary	x	x	x	32400
29
Sheet4

Cell Formulas
Range	Formula
H5:J7	H5	=LET(x,XLOOKUP(A2:A9,A21:A28,E21:E28,""),FILTER(HSTACK(CHOOSECOLS(A2:E9,1,5),x),(COUNTIFS(A21:A28,A2:A9))*(x<>E2:E9)))
Dynamic array formulas.

 

[uk747]

perfect thanks

 

[Fluff]

You're welcome & thanks for the feedback.