When will the lambda function be available

Question

I am using Excel version 2105 (build 14026.20308) as part of Microsoft 365 (I am currently running Win10/64 bit, version 2004, build 19041.1052).

I was trying to learn the lambda function – following the examples in the help section – no matter what I do I get a #NAME error. Is that because I don't actually have access to the lambda function? How do I get it?

Answer 1

Back in Feb MS posted the following blog entry about Lambda() going GA

.

2022 02 08- Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Project

https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambdas-to-production-and-advanced-formula/ba-p/3073293

Published Feb 08 2022 08:55 AM 24.3K Views

<snip>

We are excited to announce that LAMBDA and LAMBDA helper functions are now generally available to anyone using Production: Current Channel builds of Excel.

.

In conjunction with LAMBDA going to production, we are also announcing the release of a new add-in, the advanced formula environment, sponsored by the Microsoft Garage and Microsoft Research, which allows easy import/export and authoring of named LAMBDAs.

.

Thanks to all of our Insiders for using the LAMBDA functions and giving us feedback! As a result we've also made a few changes that we'll outline below in addition to talking about the advanced formula authoring environment, a Microsoft Garage project.

Let’s start with a quick example.

...

.

Accessing LAMBDA functions today

LAMBDA is now available to Office 365 Subscribers in Production: Current Channel

To get access to LAMBDA functions, please make sure you have updated to the latest version of Excel. Specifically versions greater than or equal to:

• Windows: 16.0.14729.20260
• Mac: 16.56 (Build 21121100)
• iOS: 2.56 (Build 21120700)
• Android: 16.0.14729.20176

</snip>

See the article for more details.

Answer 2

Unlocked.

Answer 3

Hi BillDoub!

I'm Jen, an independent advisor and a Microsoft user like you. I'd be happy to help you out with this issue.

Currently the LAMBDA function is only available to Microsoft 365 users on the Office Insider beta channel. It will be rolled out to all Microsoft 365 users over time, but it will not be made available in Excel 2019 or earlier. You may also check this thread for more information.

https://techcommunity.microsoft.com/t5/excel/wh...

I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

Best Regards!

Jen :)