Microsoft
Microsoft
"By coincidence, i posted a very similar idea in the 'Announcing LET' post recently. As suggested in that comment, it'd be awesome to have a complementary MAP function that iterates over the parameter values."
I remember when you mentioned this! We actually discussed this amongst ourselves because we obviously knew what we had going on behind the scenes but couldn't unveil our plans just yet. I must say you have a way with looking into the future : )
As for a map function, that is another great suggestion and I will leave it at that...
Addendum: a few simple tests show LAMBDA can be used outside of defined names if desired.
For example both formulas below return the spilled array {1,4,9,16,25}
=LAMBDA(x,x^2)({1,2,3,4,5})
=LET(square, LAMBDA(x,x^2), square({1,2,3,4,5}))
Yes! As I mentioned in a previous response, lambdas are indeed new values which excel understands, like we introduced with data types. Your proof above clearly showcases this!