When using SUMPRODUCT, is it possible to have the function return a
String instead of only numbers?

Example:
A1:Z1 - Range (1-2) Repeating
A2:Z2 - Alphabet (A-Z)
A3:Z3 - Cell ID (A3, B3, etc)

E1: =SUMPRODUCT(--(1=A1:Z1)*--("A"=A2:Z2)*A3:Z3)

If I do my array math correctly, it should be: {1,0,1,0....,1,0} *
{1,0,0,0,....,0} * {"A3","B3",...."Z3"} = "A3" -- but instead, I
recieve the #VALUE! error.

Any ideas?

Thanks,
JC


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=390411