Forum Discussion
laptopacademy
Apr 21, 2021Copper Contributor
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
Rajesh_Sinha
Apr 21, 2021Iron Contributor
The recently launched LAMBDA doesn't works with older version of Excel,,, hope you are using either Office 365 or Office Insider !!
- laptopacademyApr 21, 2021Copper Contributor
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
- Rajesh_SinhaApr 21, 2021Iron Contributor
Use this Link... or this one also,,, or check this, all are useful to learn more about LAMBDA More on LAMBDA !!