Paste this

=IF(ISERROR(MATCH(B1,A:A,0)),"Not in both columns","In both columns")

into cell C1 and copy down

hth

Dave