Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Lambda - Excel for the web

Copper Contributor

This announcement - LAMBDA function ( - 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

3 Replies


It definitely will be returned back. Nobody knows when, hope soon.

@Sergei Baklan  You are an MVP so you definitely know the answer to this question.

@David Hager 

Lambdas work on Web, aren't?