Comparing Excel Sheets

[Brendaly]

Hi,

I have a problem. I do have an ecxel sheet lets say from October and now another one from November. Both have websites and visits in them. Now I want to find out which of the sites from October are in November as well so I don't have to look at them again.

Can you understand what I mean? ^^

Can you please help me? I tried a few things already but nothing really works out...

[noexcel=badwork]

try this code:
=IF(ISNA(VLOOKUP(A:A,Sheet2!$A$1:$B$2,2,FALSE)),"","available")
your data in sheet1&2

[Brendaly]

Hi, thanks for your quick answer.

Unfortunately I think it doen't work. Cause it gives me a '0' in all rows even tho some are in both sheets.

So I have:

Sheet 1:
www.a.com
www.b.com
www.c.com

Sheet 2:
www.d.com
www.a.com
www.e.com

And if I put the formel in you gave me it just says '0' in all the rows even tho 'www.a.com' is repeated/in both sheets.

Am I doing something wrong? Any other ideas?
I really appreciate your help!!

[noexcel=badwork]

hi
it's working fine
check the attached

[Brendaly]

thank you very much for that :-)
it helps a lot!

One more problem tho: Do both list have to have the same number of rows for some reason? Cause it works fine in the beginning of my list, but not in the end. So it shows me on 'available' but I know there must be more... So the list in sheet 2 is much shorter than the list in sheet 1. Could that be the reason?

Thanks sooo much for your help!!!

[Brendaly]

found it myself

thanks again!!!!!