Forum Discussion
name manager rejecting lambdas
I tried pasting a lambda in name manager but excel refused. I belive that it's because either it is too long (which it isnt) or it has too many optional parameters (8). Anyone knows why name manag...
What is LET(...) here? May be issue with LET functions parameters. Below formula works fine with name manager. For a simple calculation I have just used SUM() inside LET() function.
=LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(x,array,y,slice1,SUM(x,y)))