In an empty column in Sheet 1 and assuming names are in column A in both
sheets:

=IF(COUNTIF(Sheet2!A:A,A1),"","Not found")

Copy this formula down for names in column A of sheet1.

HTH

"Michael" wrote:

Hi,
I have what I hope is a small problem and since I only tend to use excel to
export to and for financial information I am a little stumped.

I have been given 2 excel sheets each with similar information (esentially
they are names and addresses) is there any way I can compare the 2 sheets by
surname with the result telling me which surnames in sheet 1 aren't in sheet
2?

Many thanks help is much appreciated

Michael