Forum Discussion
Degenerate MAP blows up Excel
Does this formula work for you? =MAP(0,1,LAMBDA(x,y,x+y)) Which Build are you on? I am stuck on 2406 because all Builds since blow up when running my spreadsheets - which, as I type this, JUST MIG...
MAP requires arrays as parameters. In many cases auto-lifting from scalar to array works in Excel, but not always. That's not only with two-arrays MAP, in some other cases as well. And nobody promised auto-lifting shall always work. Thus, where needed we may use explicit conversion, e.g. in case of constants
=MAP( {0}, {1}, LAMBDA(x,y, x+y))works. Auto-lifting from ranges to arrays in such formula works implicitly, e.g.
=MAP( A1, A2, LAMBDA(x,y, x+y))works.
By the way, not sure on which Excel you are. Build number could say something for perpetual license. For the subscription model build number actually doesn't matter, more important on which channel you are.