Forum Discussion
dror_erez
Dec 21, 2025Occasional Reader
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...
Harun24HR
Dec 23, 2025Bronze Contributor
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)))