Mar 15 2022 04:07 AM
This announcement - LAMBDA function (microsoft.com) - appears to suggest that the Lambda function should work in Excel for the Web, and indeed the associated Advanced Formula Environment is live on Excel for the Web. However at present, while Lambda is now available in the standard 365 desktop Excel, Lambda seems to still return a #NAME? error when used in Excel for the Web. For interoperability it would be great to understanding whether the intention is to make Lambda available in Excel for the Web, and when this might happen.
Many thanks
Mar 15 2022 04:10 AM
It definitely will be returned back. Nobody knows when, hope soon.
Dec 11 2022 02:02 PM
@Sergei Baklan You are an MVP so you definitely know the answer to this question.