Forum Discussion
Why does LAMBDA function return #NAME?
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
I think the functionality still requires the Beta Channel
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))
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.
Are you able to assist with the license problem; time to acknowledge I am out of my depth.
- 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.
=LUse this Link... or this one also,,, or check this, all are useful to learn more about LAMBDA More on LAMBDA !!
