4 ms·
Yeah that wasn't the best example on my part. But I have tried it and confirmed that calling lambdas defined in another grid cell doesn't work. Specifically:
by ripley12 6y ago
Yeah that wasn't the best example on my part. But I have tried it and confirmed that calling lambdas defined in another grid cell doesn't work.
Specifically:
1) Put =LAMBDA(x, x+1) in A1
2) Try calling =A1(1) from any other cell - it will return #REF!
I'm on the Office Insiders beta track and LAMBDA does work otherwise.