SOLVED

I'm having trouble finding the LAMBDA function

%3CLINGO-SUB%20id%3D%22lingo-sub-3069122%22%20slang%3D%22en-US%22%3EI'm%20having%20trouble%20finding%20the%20LAMBDA%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3069122%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20go%20to%20the%20list%20of%20functions%2C%20LAMBA%20is%20not%20there%2C%20and%20when%20I%20follow%20examples%20on%20Microsoft's%20website%20I%20get%20a%20%23NAME%3F%20error.%3C%2FP%3E%3CP%3EI've%20also%20downloaded%20example%20files%20and%20gotten%20the%20%23NAME%3F%20error%3C%2FP%3E%3CP%3EEven%20something%20simple%20like%20%3DLAMBDA(x%2Cx*x)(3)%20gives%20me%20the%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20haven't%20been%20able%20to%20find%20any%20recent%20posts%20about%20LAMBDA%20being%20missing%20from%20Excel%3C%2FP%3E%3CP%3ESome%20information%20I've%20found%20says%20I%20should%20have%20it%2C%20but%20I'm%20confused.%20Some%20older%20information%20from%202020%20says%20you%20have%20to%20be%20an%20Office%20Insider%2C%20but%20some%20newer%20info%20from%20last%20year%20says%20it's%20now%20included%20if%20you%20have%20a%20365%20subscription.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Microsoft%20Office%20365%20Family%20subscription.%3C%2FP%3E%3CP%3EExcel%20Version%202112%20(Build%2014729.20260%20Click-to-Run)%3C%2FP%3E%3CP%3EI've%20checked%20Office%20Updates%20and%20it%20says%20that%20Excel%20is%20up%20to%20date.%3C%2FP%3E%3CP%3EI'm%20on%20Windows%2010%20Home%2010.0.19044%20Build%20190044%3C%2FP%3E%3CP%3EI%20just%20checked%20Windows%20update%20and%20there%20are%20no%20non-optional%20updates%20available.%3C%2FP%3E%3CP%3EI've%20rebooted.%3C%2FP%3E%3CP%3EThat's%20everything%20I%20can%20think%20of%20that%20anyone%20might%20ask.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ENoe%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3069122%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3130163%22%20slang%3D%22en-US%22%3ERe%3A%20I'm%20having%20trouble%20finding%20the%20LAMBDA%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3130163%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20issue%20%3A%2F%2F%20anyone%20heelppp%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1283721%22%20target%3D%22_blank%22%3E%40Noeotbs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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.