Compare 2 tables in excel and return mismatch data only in a separate Column

[sanj1982]

I have 2 Table in Sheet1 as texts.
Table_1 - range(A2:A500)
Table_3 - range(O2:O500)
I want to compare text in table_3 one by one and check whether same is present in table_1.
If text match - no return is required.
If text is not match - then return the not match text in column M.

 

[Toadstool]

Hi Sanj1982,

Is this what you want?

Sanj1982.xlsx
	A	B										L	M	N	O
1	Find												Differences		Sorted
2	BTC A												Pigeon		Sheep
3	BTC B												Rabbit		Raven
4	Dog												Crocodile		Pigeon
5	Cat														Mole
6	Mole														Goat
7	Goat														Rabbit
8	Raven														Crocodile
9	Sheep														BTC B
10															BTC A
Sheet1

Cell Formulas
Range	Formula
M2:M10	M2	=IFERROR(INDEX(Table3[Sorted],AGGREGATE(15,6,ROW(Table3[Sorted])-ROW($M$1)/(ISNA(MATCH(Table3[Sorted],Table1[Find],0))),ROW()-ROW($M$1))),"")