Comparing Data between two sheets

I am trying to compare the data between two sheets to locate matches. I have
attempted the Countif, Or(exact) and =ISNA(Match) - they all produce
results..but when checking..the results are innaccurate.

For example...Comparing Unigue ID on Sheet 1 to Unigue ID on Sheet 2.

If I use =COUNTIF('sheet1'!AB2:AB210,G2)>0
I get a value of False in all rows...

What should I be using to obtain this information?

Thanks!

First of all you are not using the COUNTIF funcion correctly. You should use
a conditional sentence inclosing it..sthing like.
=if(COUNTIF('sheet1'!AB2:AB210,G2)>0);"Duplicate";"Not Duplicate")
this is one way... theoretically it should work.
Whenever i have this problem i use instead:
=if(iserror(vlookup('sheet1'!AB2:AB210;G2;0));"Not Duplicate";"Duplicate")
Hope this helps,

Albion - Argentina

"AChesley" <[email protected]> escribió en el mensaje
news:[email protected]...
> I am trying to compare the data between two sheets to locate matches. I
have
> attempted the Countif, Or(exact) and =ISNA(Match) - they all produce
> results..but when checking..the results are innaccurate.
>
> For example...Comparing Unigue ID on Sheet 1 to Unigue ID on Sheet 2.
>
> If I use =COUNTIF('sheet1'!AB2:AB210,G2)>0
> I get a value of False in all rows...
>
> What should I be using to obtain this information?
>
> Thanks!
>