something like

=IF(Isnumber(match(a2,'Sheet2'!A:A,0)),"","No Match")

copied down.