Chuck thanks so much this is exactly what I was after - however works so well
it now leads to me to one more question.

Below is a snippet of what I get once I follow your suggestion - what do I
need to add to the formula to have Column A return the actual wording used on
the actual sheet ie sheet 1 name - sheet two is a different name and so on so
in other words instead of no Match in that particular column I want the
actual word in which ever sheet to show

Hope this is clear enough :-)


A B C
NoMatch NoMatch 4.1

--
Thanks

Lise


"CLR" wrote:

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