Element not allowed inside an array in a LAMBDA function

Question

Can anyone advise why&nbsp; &nbsp;the array expression {a,b} in the LAMBDA expression below generates an error.=LAMBDA(a,b,IF(a&lt;b,{0,0},{a,b}))(1,2)it indicates, "element not allowed inside an array"Thanks

sergeibaklan · Answer

LBROWN7&nbsp;
{...} assumes constants inside. You may try
=LAMBDA(a,b,IF(a&lt;b,{0,0}, HSTACK(a,b)))(1,2)

lbrown7 · Answer

Thanks!! This is correct.If a &amp; B are names ={a,b} fails, but ={1,2} works!!Follow up Question is this issue concerning the Excel Braces Array Constructor only working with numbers documented anyplace?Thanks

sergeibaklan · Answer

LBROWN7&nbsp;
Not only numbers, any constants. Texts, Boolean, e.g. ={true, false}
Use array constants in array formulas - Microsoft Support

hansvogelaar · Answer

LBROWN7&nbsp;
"Excel Braces Array Constructor only working with numbers"
&nbsp;
That is not entirely correct. It works only with constant values, including text strings, TRUE/FALSE and error values. For example, the following is valid:
&nbsp;
{"Excel", 37, TRUE, #N/A}
&nbsp;
See Guidelines and examples of array formulas section 'Array constant syntax':

lbrown7 · Answer

Thanks, the Excel Braces constructor generates an Array CONSTANT.I wrongly assumed it generated a generic Array.Now in a LAMBDA function where all names are immutable, relaxing this constraint (on constant VALUES) to allow immutable names would be great, as the braces constructor would still generate and Array CONSTANT.NOTE - in a normal Excel formula&nbsp; global and sheet names are not&nbsp;immutable, hence the braces constructor would not generate an Array Constant.

Forum Discussion

Element not allowed inside an array in a LAMBDA function

5 Replies

Resources