Forum Discussion
Excel Scan versus Reduce LAMBDA Issue
=REDUCE({1}, {2, 3, 4}, LAMBDA(acc, cv, VSTACK(acc, cv))) Works fine in Excel and Google Sheets. =SCAN({1}, {2, 3, 4}, LAMBDA(acc, cv, VSTACK(acc, cv))) generates and Error ...
Hard to say is that a bug or missed feature, depends on your attitude. Excel doesn't support array of arrays since its calc engine was designed so long before dynamic arrays are introduced.
Different kind of workarounds exist, but no native support.