Forum Discussion

Manish4993's avatar
Manish4993
Copper Contributor
Apr 25, 2021
Solved

Need help on Lambda #VALUE error

Hi Experts,

 

Please help me to catch the error with below LAMBDA function:

 

=LAMBDA(DOP,Sqdop,SqEoo,Model,SqModel,Insname,Sqinsname,OfferName,IFS(AND(DOP>=Sqdop,DOP<=SqEoo,Model=SqModel,Insname=Sqinsname),OfferName))

 

After passing the correct parameters it is still show the #value error

Formulas and Functions
office 365

11 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 25, 2021

    Manish4993 Difficult to diagnose this without seeing the file and the formula at work. But the MS support page for LAMBDA says this:

    So, are you really passing all (and not too many) arguments? And I assume that you have named your function something like "CheckDOP" in the Name Manger and that the Lambda function expression is entered there. And then, when you call the function you enter something like =CheckDOP(..........) with all eight parameters between the brackets.

    If all of this makes no sense at all, perhaps you can upload you workbook. Remove any private or confidential information, though.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 25, 2021

        Manish4993 

        You call with has 9 parameters lambda which has only 8 ones. If you have no recursion it's always better to test formula on simple LET and after that wrap by LAMBDA

        =LET(
 DOP,       Data!B2,
 Sqdop,     'Sales Qty'!E2,
 SqEnd,     Data!B2,
 Model,     'Sales Qty'!F2,
 Sqmodel,   Data!A2,
 INSname,   'Sales Qty'!D2,
 SqInsname, Data!E2,
 Offername, 'Sales Qty'!C2,
 IFS(AND(DOP>=Sqdop,DOP<=SqEnd,Model=Sqmodel,INSname=SqInsname),Offername,
     TRUE, 'Sales Qty'!A2)
)

         

Resources