Forum Discussion
Need help on Lambda #VALUE error
Manish4993 Just as I suspected and SergeiBaklan pointed out, you have one argument too many. See attached.
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.
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) )- Both the data set ranges will go long and i will also use the recursion to make it dynamic. So i don't know the actual error that need to be solved as pet attached file.
