Use this in A1 and to copy around on sheet4

=IF(AND(Sheet1!A1=Sheet2!A1, Sheet1!A1=Sheet3!A1),Sheet1!A1,"NoMatch")


Vaya con Dios,
Chuck, CABGx3



"Lise" wrote in message
...
Good morning

I have three worksheets with the same amount of columns across each and
the
same column headings - These columns show Paragraph numbers etc then list
any
changes made to the paragragh - I want to:

*be able to compare all three worksheets and if a line is the same in all
three
*copy the specific line from each into a fourth worksheet

Sorry have tried to detail clearly - Can this be done?

Thanks as always