Vlookup

try this code:

=IF(ISNA(VLOOKUP(Sheet1!A:A,Sheet2!$A$1:$B$5,2,FALSE)),"","Duplicate")

supposing your data in sheet1&2

Originally Posted by noexcel=badwork

try this code:

=IF(ISNA(VLOOKUP(Sheet1!A:A,Sheet2!$A$1:$B$5,2,FALSE)),"","Duplicate")

Just so I am understanding this correctly, the Sheet1 is the sheet where the data is, the A:A is saying to look in all rows of column A?? then again Sheet2 is the sheet where the data I want to compare is, and the $A$1:$B$5$ is the locations in Sheet2 that I am wanting to Compare. What are the 2, False and ""? And I am assuming that "Duplicate" is there because if they are duplicates this is the word that will populate?