Compare Columns on different Sheet

[Andrew.Trevayne]

Hi,
Just wanted to ask how to go about this thur VLookUp
On Sheet 1 I have a list of Names on Column A
On Sheet 2 I have a list of Names as well on Column A
How do i do a compare between these two sheets?
What I basically want is to list the Unique value between these sheets (Sheet 1 & 2) and return it on Sheet 2 Column B.

I have attached a sample sheet. Thanks in advance.

[davesexcel]

Something like this in B2 then drag the formula down

=IF(COUNTIF(Sheet1!$A$2:$A$8,A2)=0,"Unique","")

[Andrew.Trevayne]

Thanks.
But it didn't actually compare.
It only tagged the XXX and the YYY on Sheet 2 with the word "Unique"
I was actually hoping it would list the difference.
In this case i would like the return to be something like:

BBBB
CCCC
FFFF
XXXX
YYYY


Hope you could help. Thanks.

[davesexcel]

Yes, I see what you mean.