try this code:
=IF(ISNA(VLOOKUP(Sheet1!A:A,Sheet2!$A$1:$B$5,2,FALSE)),"","Duplicate")
supposing your data in sheet1&2