IF Statement Comparison in Excel spreadsheet

elizabeth1 · #1 (**permalink**) 04-13-10, 17:40

I'm trying to compare cells in a spreadsheet that has 2 worksheets.

Example: I need to compare the data in Sheet 1,rows A5:I5 with the corresponding cells in Sheet 2. If the data in both match then the result should be "Yes" and "No" if the data doesn't match.

Any suggestions? Any help will be appreciated.

weejas · #2 (**permalink**) 04-15-10, 10:39

What you need depends on which sheet needs to show the comparison, and whether you're showing a match cell for cell, or just in total. Working on the assumption that sheet 1 needs to show the comparison, and you're working cell by cell, enter the following in A6 on sheet 1:

Code:

=IF(A5 = Sheet2!A5, "Yes", "No")

Copy this across to I6.
Then, in A7, enter this:

Code:

=COUNTIF(A6:I6, "Yes")

HTH!

elizabeth1 · #3 (**permalink**) 04-15-10, 15:24

To Weejas:

I appreciate the help. Thanks.

ExcelGuru545 · #4 (**permalink**) 04-22-11, 14:30

Make sure your sheet reference has quotations around it. This will protect you against errors if you have spaces in your sheet names.

-C.W.
Excel Statement

Internet Services

Web Development

Digital Marketing

Consumer Tech