MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Identifying Duplicates


Posted by FD_Scott on September 26, 2001 6:55 AM

I have two lists of 6 digit numbers. I would like to identify which values in the first list have an identical value in the second list... What can I use as a formula?

Thanks


Posted by Barrie Davidson on September 26, 2001 7:00 AM

How about using a VLOOKUP formula? Something like:

=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$A4000,1,0)),"No Match","Match")


Where your second list is on Sheet2.

Regards,
BarrieBarrie Davidson