Forum Discussion
Potential Bug: SEQUENCE Function Misbehaves with Dynamic start Parameter from BYROW/LAMBDA
Dear Microsoft Excel Team, I’m encountering unexpected behavior when using SEQUENCE inside a BYROW/LAMBDA construction, specifically when the start parameter of SEQUENCE is derived from the lambd...
Hello.
It's not a bug, but a trap!
Simplified version of the formula.
=BYROW({4;3}, LAMBDA(p,TEXTJOIN(" ",, SEQUENCE(5,,INDEX(p;1),4))))
The SEQUENCE function expects a value for the Start argument, but it's an array of one value. Therefore, you need to extract the value from the array with INDEX.