comparing 2 sheets

R

rodchar

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
 
M

Max

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
 
Top