Find two names

[Sheepkin_Coat]

I have a 2 sheets with names on and i want to compare the sheets to see if there are duplicates and then in column put a yes.

Sheet 1
Column 1
Name Name

Sheet 2
Column 1 Column 2
Name Name (Yes)

Can somebody help me with this please

[Pete_UK]

You can try this formula in cell B1 of Sheet2:

=IF(ISNUMBER(MATCH(A1,Sheet1A:A,0)),"Yes","")

then copy down as far as you need to.

Hope this helps.

Pete

[Sheepkin_Coat]

Thats great, how do i get the "yes" on sheet 1

[Pete_UK]

Put this formula in B1 of Sheet1:

=IF(ISNUMBER(MATCH(A1,Sheet2A:A,0)),"Yes","")

then copy that down.

Hope this helps.

Pete

[Sheepkin_Coat]

Put this formula in B1 of Sheet1:

=IF(ISNUMBER(MATCH(A1,Sheet2A:A,0)),"Yes","")

then copy that down.

Hope this helps.

Pete

Hi Pete

When i type this in i get a blank cell and the formula puts a bracket around the second A after the colon, what have i done wrong

[Pete_UK]

Sorry, I missed the exclamation mark - it should be this:

=IF(ISNUMBER(MATCH(A1,Sheet2!A:A,0)),"Yes","")

Hope this helps.

Pete

[Sheepkin_Coat]

Hi sorry i still get blank cells, does it matter that the name in column A sheet 1 is like this James Colman and the name in sheet 2 is James Colman

[Pete_UK]

That should be okay unless you have extra spaces in the middle of one name or at the end. Can you attach a sample workbook?

Pete

[Sheepkin_Coat]

That should be okay unless you have extra spaces in the middle of one name or at the end. Can you attach a sample workbook?

Pete

Yes sorry i got it working thanks again

[Pete_UK]

Okay, thanks for the rep - please mark your thread as Solved, as follows:

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete