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!