Lambda - Excel for the web

Frequent Visitor

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?