Why does LAMBDA function return #NAME?

%3CLINGO-SUB%20id%3D%22lingo-sub-2279705%22%20slang%3D%22en-US%22%3EWhy%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279705%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20created%20a%20LAMBDA%20function%20in%20name%20manager.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EName%3A%20MyLamb%3C%2FP%3E%3CP%3ERefers%20To%3A%20%3DLAMBDA(a%2C%20a%2B99)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20i%20enter%20onto%20sheet%3A%20%3DMyLamb(5)%20The%20cell%20displays%3A%20%23NAME%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat's%20the%20problem%3F%20thx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279705%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281585%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022814%22%20target%3D%22_blank%22%3E%40laptopacademy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26lt%3B%3CSPAN%3E%3CSTRONG%3EOr%20will%20my%20system%20get%20polluted%20by%20the%20beta%3F%3C%2FSTRONG%3E%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20like%20it.%26nbsp%3B%20Only%20I%20think%20of%20it%20as%20an%20acceptable%20dynamic%20array%20solution%20being%20polluted%20by%20legacy%20practices%20that%20I%20am%20only%20too%20glad%20to%20see%20the%20back%20of.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281260%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281260%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022814%22%20target%3D%22_blank%22%3E%40laptopacademy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20there%20are%20several%20ways%20to%20switch%20from%20one%20channel%20to%20another.%20All%20work%2C%20but%20which%20to%20use%20depends%20on%20your%20scenario%20of%20work.%20You%20may%20switch%20on%20any%20available%20channel%20at%20any%20time.%20From%20semi-annual%20to%20beta%2C%20from%20beta%20back%20on%20current%2C%20etc.%20No%20problems%20with%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281244%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281244%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20the%20admin%2C%20under%20the%20free%20Developer%20License.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fdev-program%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fdev-program%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20found%20a%20few%20ways%20to%20enable%20the%20beta%20channel%3A%20gpedit%2C%20registry...%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fchange-update-channels%3FWT.mc_id%3DM365-MVP-5002016%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fchange-update-channels%3FWT.mc_id%3DM365-MVP-5002016%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupertekboy.com%2F2021%2F01%2F05%2Fhow-to-switch-to-the-office-m365-apps-beta-channel%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fsupertekboy.com%2F2021%2F01%2F05%2Fhow-to-switch-to-the-office-m365-apps-beta-channel%2F%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20if%20i%20later%20revert%20back%20to%20current%2C%20would%20it%20be%20a%20clean%20rollback%3F%20Or%20will%20my%20system%20get%20polluted%20by%20the%20beta%3F%3CBR%20%2F%3E%3CBR%20%2F%3Ethx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280718%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280718%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20not%20sure%20how%20may%20I%20help.%20No%20additional%20Office%20licenses%20is%20required%2C%20what%20is%20required%20that's%20administrative%20rights%2C%20at%20least%20on%20machine.%3C%2FP%3E%0A%3CP%3EI%20do%20not%20recommend%20to%20install%20beta%20as%20main%20version%2C%20even%20if%20it's%20stable%20enough.%20Main%20issue%20is%20compatibility%26nbsp%3B%20working%20in%20corporate%20environment.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20I%20do%20-%20on%20my%20office%20machine%20I'm%20on%20Current%20channel%2C%20virtual%20(Hyper-V)%20machine%20is%20installed%20on%20the%20same%20computer%20and%20on%20it%20with%20Office%20Deployment%20Tool%20Beta%20channel%20is%20installed.%20Office%20is%20under%20the%20same%20license%20since%20365%20subscription%20allows%20to%20install%20it%20on%20few%20computers%20for%20the%20same%20user.%20The%20only%20with%20such%20solution%20is%20licensing%20of%20Windows%20on%20VM%20is%20required.%20Any%20license%20for%20non-commercial%20use%20works%2C%20this%20is%20not%20for%20business.%20That's%20better%20to%20ask%20local%20IT%20what%20they%20could%20suggest.%3C%2FP%3E%0A%3CP%3EOn%20my%20home%20machine%20main%20(and%20the%20only%20one)%20is%20Beta%20channel%2C%20I%20see%20no%20problems%20working%20on%20it.%20It%20could%20be%20under%20the%20same%20corporate%20Office%20365%20subscription.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20it'll%20be%20in%20production%20-%20nobody%20knows.%20My%20understanding%20of%20the%20situation%20is%20that%20with%20current%20lambdas%20Microsoft%20only%20touch%20the%20water%20collecting%20feedback%20from%20insiders.%20After%20that%20it%20shall%20be%20mockup%20of%20lambdas%20production%20version.%20Hope%20within%20few%20months.%20This%20version%20also%20will%20be%20tested%20on%20insiders%20channels%20first.%20More%20complex%20functionality%20more%20time%20that%20takes.%20Time%20frame%20also%20depends%20on%20current%20priorities.%20I%20guess%20another%20few%20months%2C%20at%20least.%20Next%20is%20production%2C%20channel%20by%20channel.%20So%2C%20not%20in%20nearest%20future.%20Will%20be%20happy%20if%20I'm%20wrong.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20roadmap%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Froadmap%3Ffilters%3DExcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%20365%20Roadmap%20%7C%20Microsoft%20365%3C%2FA%3E%2C%20nothing%20about%20lambdas%20in%20it.%20On%20the%20other%20hand%20it's%20not%20well%20supported.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280149%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280149%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022814%22%20target%3D%22_blank%22%3E%40laptopacademy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20think%20it%20is%20a%20question%20of%20being%20ineligible.%26nbsp%3B%20It%20is%20more%20a%20question%20that%20access%20through%20enterprise%20licenses%20is%20set%20by%20IT%20management.%26nbsp%3B%20If%20you%20%3CU%3Eare%3C%2FU%3E%20IT%20management%20that%20still%20leaves%20you%20with%20a%20problem%20to%20solve!%3C%2FP%3E%3CP%3EI%20wouldn't%20like%20to%20guess%20a%20timescale.%26nbsp%3B%20The%20new%20functionality%20is%20revolutionary%20in%20terms%20of%20how%20one%20might%20go%20about%20the%20creation%20of%20Excel%20solutions%2C%20but%20the%20development%20environment%20is%20immature%20and%20there%20are%20severe%20limitations%20on%20the%20permitted%20depth%20of%20recursion.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20able%20to%20assist%20with%20the%20license%20problem%3B%20time%20to%20acknowledge%20I%20am%20out%20of%20my%20depth.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280004%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3Bi%20think%20i'm%20not%20eligible%20for%20beta.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22laptopacademy_0-1619008892824.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274237i621CEC53CFE41A89%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22laptopacademy_0-1619008892824.png%22%20alt%3D%22laptopacademy_0-1619008892824.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20when%20LAMBDA%20is%20coming%20out%20of%20beta%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279751%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279751%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022814%22%20target%3D%22_blank%22%3E%40laptopacademy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20functionality%20still%20requires%20the%20Beta%20Channel%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20522px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274207i0FDE84D09A3D7165%2Fimage-dimensions%2F522x105%3Fv%3Dv2%22%20width%3D%22522%22%20height%3D%22105%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20else%20you%20could%20try%20is%20to%20avoid%20the%20excursion%20to%20Name%20Manager%2C%20which%20can%20easily%20conceal%20typing%20errors%2C%20and%20just%20use%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DLAMBDA(a%2Ca%2B99)(5)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eon%20the%20worksheet%20without%20any%20naming.%26nbsp%3B%20A%20rather%20more%20complicated%20test%20involves%20applying%20a%20local%20name%20within%20the%20cell%20by%20using%20the%20%3CSTRONG%3ELET%3C%2FSTRONG%3E%20function%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20LET(%3CFONT%20color%3D%22%230000FF%22%3EmyLambda%2C%20LAMBDA(a%2Ca%2B99)%3C%2FFONT%3E%2C%20myLambda(5))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279747%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279747%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022814%22%20target%3D%22_blank%22%3E%40laptopacademy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EUse%20this%20Link...%3C%2FA%3E%26nbsp%3B%20or%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2Fblog%2Flambda-excel-custom-functions%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%20this%20one%20also%2C%2C%2C%3C%2FA%3E%26nbsp%3Bor%20check%20this%2C%20all%20are%20useful%20to%20learn%20more%20about%20LAMBDA%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.myexcelonline.com%2Fblog%2Flambda-function-in-excel%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMore%20on%20LAMBDA%20!!%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279720%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279720%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20i%20have%20Office%20365%20with%20free%20Developer%20license.%20LAMBDA%20doesn't%20appear%20in%20the%20built-in%20function%20list%2C%20but%20if%20i%20start%20typing%20formula%20in%20a%20cell%2C%20it%20comes%20up.%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DL%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279717%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20does%20LAMBDA%20function%20return%20%23NAME%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279717%22%20slang%3D%22en-US%22%3EThe%20recently%20launched%20LAMBDA%20doesn't%20works%20with%20older%20version%20of%20Excel%2C%2C%2C%20hope%20you%20are%20using%20either%20Office%20365%20or%20Office%20Insider%20!!%3C%2FLINGO-BODY%3E
Occasional Contributor

i created a LAMBDA function in name manager.

 

Name: MyLamb

Refers To: =LAMBDA(a, a+99)

 

Then i enter onto sheet: =MyLamb(5) The cell displays: #NAME?

 

What's the problem? thx

10 Replies
The recently launched LAMBDA doesn't works with older version of Excel,,, hope you are using either Office 365 or Office Insider !!

Yes, i have Office 365 with free Developer license. LAMBDA doesn't appear in the built-in function list, but if i start typing formula in a cell, it comes up. 

=L

 

@laptopacademy 

Use this Link...  or  this one also,,, or check this, all are useful to learn more about LAMBDA More on LAMBDA !! 

@laptopacademy 

I think the functionality still requires the Beta Channel 

image.png

 

Something else you could try is to avoid the excursion to Name Manager, which can easily conceal typing errors, and just use

=LAMBDA(a,a+99)(5)

on the worksheet without any naming.  A rather more complicated test involves applying a local name within the cell by using the LET function

= LET(myLambda, LAMBDA(a,a+99), myLambda(5))

 

@Peter Bartholomew i think i'm not eligible for beta.

 

laptopacademy_0-1619008892824.png

 

Any idea when LAMBDA is coming out of beta?

@laptopacademy 

I don't think it is a question of being ineligible.  It is more a question that access through enterprise licenses is set by IT management.  If you are IT management that still leaves you with a problem to solve!

I wouldn't like to guess a timescale.  The new functionality is revolutionary in terms of how one might go about the creation of Excel solutions, but the development environment is immature and there are severe limitations on the permitted depth of recursion.

@Sergei Baklan 

Are you able to assist with the license problem; time to acknowledge I am out of my depth.

@Peter Bartholomew 

I'm not sure how may I help. No additional Office licenses is required, what is required that's administrative rights, at least on machine.

I do not recommend to install beta as main version, even if it's stable enough. Main issue is compatibility  working in corporate environment. 

How I do - on my office machine I'm on Current channel, virtual (Hyper-V) machine is installed on the same computer and on it with Office Deployment Tool Beta channel is installed. Office is under the same license since 365 subscription allows to install it on few computers for the same user. The only with such solution is licensing of Windows on VM is required. Any license for non-commercial use works, this is not for business. That's better to ask local IT what they could suggest.

On my home machine main (and the only one) is Beta channel, I see no problems working on it. It could be under the same corporate Office 365 subscription.

 

When it'll be in production - nobody knows. My understanding of the situation is that with current lambdas Microsoft only touch the water collecting feedback from insiders. After that it shall be mockup of lambdas production version. Hope within few months. This version also will be tested on insiders channels first. More complex functionality more time that takes. Time frame also depends on current priorities. I guess another few months, at least. Next is production, channel by channel. So, not in nearest future. Will be happy if I'm wrong.

 

In general roadmap is here Microsoft 365 Roadmap | Microsoft 365, nothing about lambdas in it. On the other hand it's not well supported.

i am the admin, under the free Developer License.
https://developer.microsoft.com/en-us/microsoft-365/dev-program

I found a few ways to enable the beta channel: gpedit, registry...
https://docs.microsoft.com/en-us/deployoffice/change-update-channels?WT.mc_id=M365-MVP-5002016

https://supertekboy.com/2021/01/05/how-to-switch-to-the-office-m365-apps-beta-channel/

But if i later revert back to current, would it be a clean rollback? Or will my system get polluted by the beta?

thx

@laptopacademy 

Yes, there are several ways to switch from one channel to another. All work, but which to use depends on your scenario of work. You may switch on any available channel at any time. From semi-annual to beta, from beta back on current, etc. No problems with that.

@laptopacademy 

<Or will my system get polluted by the beta?>

I like it.  Only I think of it as an acceptable dynamic array solution being polluted by legacy practices that I am only too glad to see the back of.