Rewrite this as a NON Lambda formula? or just simplify, to solve file crashing 8192 error.

Note for speed readers: all these formulas work. This is about simplification.

This Lambda APPEARS to be causing an 8192 error and/or crashing my file, so I write to ask for suggestions how to rewrite it is in non Lambda form, unless anyone can see a reason why this Lambda can be causing this problem.

and the formula is:

=LAMBDA(INVNO,LEDGER,NL,PAYEE,LET(many,ManyPaid(NL,RAs[[#All],[LOOKUP]]),IF(many,INDEX(RAs[[#All],[CrossRefs]],many,0),Allocator(INVNO,LEDGER,NL,PAYEE))))([@INVNO],[@LEDGER],[@NL],[@Payee])

Select allOpen in new window

or:

=LAMBDA(INVNO,LEDGER,NL,PAYEE,
LET(many,ManyPaid(NL,RAs[[#All],[LOOKUP]]),
IF(many,
INDEX(RAs[[#All],[CrossRefs]],many,0),
Allocator(INVNO,LEDGER,NL,PAYEE))))
([@INVNO],[@LEDGER],[@NL],[@Payee])

and the Lambda called Allocator called from within is:
or:
LAMBDA(INVNO,LEDGER,NL,PAYEE,
LET(
Separator,",",
csv,TEXTJOIN(Separator,1,PAYEE,NL,INVNO,TEXT(LEDGER,"00000000.00;-0000000.00")),

IF(ISBLANK(LEDGER),"",csv)))

Edit:and another sub LAMBDA within is:
LAMBDA(CQS,LOOKSEE,IFNA(MATCH(CQS,LOOKSEE,0),0))


Apparently this file does run ok on some PC versions (at least one) of Excel. To reproduce the crash, first sort on Data sheet column O and then column A. If that does work then it just crashes shortly after or crashes on save.

This question is a focussed Lambda/formula question after several questions about these crash/8192 errors.

Here is the file, this formula is in DATA sheet Column headed Allocator, col  AI .

GVXkeeping37DEVoriginal.xlsx

Changing the name LOOKUP to LOOKUPQ makes no difference. That was checking for conflicted names.

I have provided feedback to MS on all this.

Anthony
Mac, MS 365 Sub, Beta channel.