If recently learned how to use the sumproduct function as a lookup for multiple criteria and it was working great, but I realize now all the values that I was returning were numbers. Is there a way to use the sumproduct under the same circumstances but to return a text value?

For example:

COL A COL B COL C

A 1 X

A 2 F

A 3 G

B 1 E

B 2 S

I would want the lookup with conditions of ColA=A and ColB=2, so the return should be "F"

=SUMPRODCUT(($A$1:$A$5="A")*($B$1:$B$5=2)*$B$1:$B$5).

Does anyone know how to fix this?

Thanks

For example:

COL A COL B COL C

A 1 X

A 2 F

A 3 G

B 1 E

B 2 S

I would want the lookup with conditions of ColA=A and ColB=2, so the return should be "F"

=SUMPRODCUT(($A$1:$A$5="A")*($B$1:$B$5=2)*$B$1:$B$5).

Does anyone know how to fix this?

Thanks

## Comment