comparing 2 sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,
i have 2 worksheets. i want to compare 1 column (Column C) and see if the
numbers are equal and put yes or no in an empty column next to it. is this
possible?

thanks,
rodchar
 
Assume identical length data running in C1 down in both Sheet1 and Sheet2.

In Sheet2,

In D1:
=IF(C1="","",IF(C1=Sheet1!C1,"Yes","No"))
Copy down to last row of data in col C.

This compares* it cell-for-cell between Sheet2 and Sheet1,
ie Sheet2's C1 with Sheet1's C1, Sheet2's C2 with Sheet1's C2, ...
*except case sensitivity


In E1:
=IF(C1="","",IF(ISNUMBER(MATCH(C1,Sheet1!C:C,0)),"Yes","No"))
Copy down to last row of data in col C

This compares* it cell-with-col between Sheet2 and Sheet1, ie
Sheet2's C1 found within Sheet1's C:C ?,
Sheet2's C2 found within Sheet1's C:C ?, and so on
*except case sensitivity
 
Back
Top