Compare and count if data elements on two worksheets are similar
 

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))

Compare and count if data elements on two worksheets are similar
 

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


"aascasacspas" wrote:

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))