Cell keeps give me an #valid error

[Guest]

I am trying to input this formual and I keep getting an #valid error. I know
that I am typing it right. Ex - =CONCATENATE(IF(Monday!R5="4D","EST
4D",Monday!R5),"
",IF(Monday!F5=B57:B60,"X",Monday!F5)+OR(Monday!F5=B64:B68,"Y",Monday!F5),"
",Monday!$D5). I know that I am typing the formual in correctly or is it
that Excel cannot handle that many different strings?

 

[Guest]

I don't think it's a string limitation........

I see the reference to 'Monday!F5=B57:B60' and 'Monday!F5=B64:B68' in your
formula. I believe a multiple cell range will not resolve with these
formulae. If you are trying to get confirmation that all cells in each range
contain the desired value, you need to try a different approach.

 

[Tom Ogilvy]

concatenate doesn't work with single cell array formulas/arrays.


if entered across 4 cells in a single row, this would produce
1A 2B 3C 4D respectively in the 4 cells

=CONCATENATE({1,2,3,4},{"A","B","C","D"})

If doesn't produce 1234ABCD or 1A2B3C4D in a single cell.