Pulling out identical cells within two columns

[almst791]

Hi guys, I simply have two columns of names. I just want a third column that lists the names that are both in column 1 and 2. and a fourth column with names that arent in both lists.

 

[FDibbins]

Try this for the matches...

	A​	B​	C​	D​
1​				match
2​	aa	bb		bb
3​	bb	dd		dd
4​	cc	ff
5​	dd	hh
6​	ee	jj

D2=IFERROR(INDEX($A$2:$A$6,MATCH(B2,$A$2:$A$6,0)),"")
copied down