Hi carlyman,

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.

I am afraid you don't do your math correctly :-) Have you ever seen a text
string, say "A3", to be multiplied by 0 or 1 and return anything, but
errorr?

If I have understood correctly, you could do something like this:

=INDEX(A3:Z3,MATCH("2E",A1:Z1&A2:Z2,0))

This formula has to be array-entered (Ctrl+Shift+Enter)

Regards,
KL