I have two reports pulled into a workbook. I am trying to match three
columns of data and bring back the results from a 4th column. I am using the
following formula, but receive "0" in every field.

Any help?

=SUMPRODUCT(--('BO Data'!$E$2:$E$65533='SAP BW Data'!D2),--('BO
Data'!$F$2:$F$65533='SAP BW Data'!B2),--('BO Data'!$G$2:$G$65533='SAP BW
Data'!A2),('BO Data'!$D$2:$D$65533))