Another option is to add a duplication check sheet. On Sheet 3 it will concenate each name from sheet1 and sheet2 (in case of any same name situations), then compare them to see if there is a match. If so it will check to see if "Card" is also listed with the duplicate name (From Sheet 1) and then puts "Duplicate" in the proper cell. Where you see "Duplicate" will indicate that the same name in the row from sheet1 is the one with the duplicate listed on sheet 2.



VLOOKUP(w Dupesheet).xlsx