Find two names

Originally Posted by 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

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