Formula required to compare names on two different work sheets

Hello,

I am using Excel 2007, I have two different work sheets, I need to find out if the names which are in column A on Sheet1 also appear on the second worksheet Sheet2, On Sheet2 the names are also in column A.

If the names do appear then I need the formula to display the word TRUE in column B on Sheet1 and if the name does not appear on Sheet2 then I need the formula to display FALSE in column B on Sheet1.

Any assistance you could give would be appreciated.

Thank you

Put this in B1 on Sheet1:

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),FALSE,TRUE)

then copy down.

Hope this helps.

Pete

Thank you Pete that worked perfectly.