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

I'm having trouble finding the LAMBDA function

Copper Contributor

When I go to the list of functions, LAMBA is not there, and when I follow examples on Microsoft's website I get a #NAME? error.

I've also downloaded example files and gotten the #NAME? error

Even something simple like =LAMBDA(x,x*x)(3) gives me the error.

 

I haven't been able to find any recent posts about LAMBDA being missing from Excel

Some information I've found says I should have it, but I'm confused. Some older information from 2020 says you have to be an Office Insider, but some newer info from last year says it's now included if you have a 365 subscription.

 

I have a Microsoft Office 365 Family subscription.

Excel Version 2112 (Build 14729.20260 Click-to-Run)

I've checked Office Updates and it says that Excel is up to date.

I'm on Windows 10 Home 10.0.19044 Build 190044

I just checked Windows update and there are no non-optional updates available.

I've rebooted.

That's everything I can think of that anyone might ask.

 

Thanks,

Noe

6 Replies

I have the same issue :// anyone heelppp@Noeotbs 

best response confirmed by Noeotbs (Copper Contributor)
Solution

@seror 

So far lambdas are available for Office Insiders only, that means you shall be on Beta or at least on Current (Preview) channel. Build number practically doesn't matter.

Thank you for your answer. I fixed it.:)

@seror , glad to help

@Sergei Baklan 

Hey, Sergei

 

Sorry, I forgot to say thank you.

 

Thanks. 

@Noeotbs , you are welcome.

In addition, right now lambda is announced for Current channel https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambdas-to-production-and-advanced-form...  .

If you are on it expect it soon. 

1 best response

Accepted Solutions
best response confirmed by Noeotbs (Copper Contributor)
Solution

@seror 

So far lambdas are available for Office Insiders only, that means you shall be on Beta or at least on Current (Preview) channel. Build number practically doesn't matter.

View solution in original post