Trying to match 3 fields in one dataset and return a text value in a 4th field.

=SUMPRODUCT(--('[Copy of
Private_Active_AFS_Portfolio_200903.xls]Guarantor'!$A2:$A35000=--LEFT(E4,5)),--('[Copy
of
Private_Active_AFS_Portfolio_200903.xls]Guarantor'!$E2:$E35000=--MID(E4,6,10)),--('[Copy
of
Private_Active_AFS_Portfolio_200903.xls]Guarantor'!$F2:$F35000=--RIGHT(E4,10)),('[Copy
of Private_Active_AFS_Portfolio_200903.xls]Guarantor'!$AD2:$AD35000))


The value I am trying to return in column AD is text. Should I alter the
formula because the return is a 0?