Forum Discussion

dror_erez's avatar
dror_erez
Occasional Reader
Dec 21, 2025

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 manager will reject to paste my lambda?

These are the parameters:

=LAMBDA(array,slice1,[index1],[return_index_slice2],[index2],[return_index],[if_not_found],[logic],[headers],[function],LET(...))

excel
Formulas and Functions
office 365

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Dec 23, 2025

    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)))

     

Resources