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
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
Use this Link... or this one also,,, or check this, all are useful to learn more about LAMBDA More on LAMBDA !!