Comparing two sets of data

[Alice]

I need to compare sets of data in two different
spreadsheets in two different columns labeled the same,
Grant Number. We are trying to track if both sets have
the same grant numbers or if there are duplicates.

 

[Dave Peterson]

Did you adjust the ranges from column Z to whatever column held your data? (and
did you remove the extra trailing close parenthesis?)

Another formula that I use is this:

I insert a helper column to the right of the Key data.

Then I use a formula like this in Grant1 (assumes data is in column B of both
sheets).

=IF(ISNUMBER(MATCH(B2,Grant2!$B$2:$B$9999,0)),"Match","not a match")

and drag down. Then I apply Data|filter|Autofilter to see what I want.