Compare and count if data elements on two worksheets are similar

A

aascasacspas

I need to compare text in a range of cellw on worksheet 1 to a cell in
worksheet 2 AND text in another range of cells in worksheet 1 to another cell
in worksheet 2. If there is a match, place a 1 in the cell on worksheet 2.
If there is not a match, place a blank in the cell on worksheet 2. Here is
the formula I am using but it does not appear to be reading the information
in worksheet 1. Worksheet 1 is 'Mapping Template'. Any ideas?
=COUNT(IF(('Mapping Template'!$D$3:$D$1500=Summary!B8)*('Mapping
Template'!$E$3:$E$1500=Summary!C8),1,0))
 
T

Teethless mama

=SUMPRODUCT(('Mapping Template'!$D$3:$D$1500=Summary!B8)*('Mapping
Template'!$E$3:$E$1500=Summary!C8))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Formula: Counting Cells on Different Worksheets 3
Excel 2010 countifs for date range 3
Syncing between source worksheet and dependent worksheets 0
Compare between 2 worksheet 0
If Condition 4
If Condition 0
Getting Radio Buttons to work, that are inserted via AutoText 0

Top