Forum Discussion
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...
Manish4993 Just as I suspected and SergeiBaklan pointed out, you have one argument too many. See attached.
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.
Actual error is different number of parameters in function and it's call.
All the rest is more about how to avoid such errors, one of main techniques is in-cell editing. With some tricks that could be used for the function with recursion. But that's in theory, you concrete function doesn't have recursion.
- If possible please share the correct formula file with me by using the same file that earlier i shared with you.