Check for duplicate values within the same worksheet

[aashishd233]

Hi,

I am looking for a macro which can find duplicates within the same workbook. My problem is as below:
1. I have an excel workbook with a bunch of fields, records in it; each record is having a unique "name" string(column b of Sheet 1).
2. I have a list of strings listed in Sheet 2(column a) organised one below the other.

I need to check each string listed in Sheet 2(column a) with the strings in Sheet 1(column b). If the sheet 2 string matches with any of the strings listed in sheet 1(column b), it should return true else return false; and place the result in column b of Sheet 2.

Is it possible?

Can anyone help? I know how programming works but don't know how to code.

Thanks in Advance!
Ashish.

[millz]

in sheet 2, cell B1 (assuming your strings start in row 1), type in:

=IF(ISNA(VLOOKUP(A1,Sheet1!B:B,1,0)),"False","True")