Forum Discussion

MichielS340's avatar
MichielS340
Copper Contributor
May 14, 2025

Array formula map lambda indirect address

Hi, 

The orange area contains a spilled array formula where I am trying to loop through a spilled array and for each cell I want to check the value and the value of last period and on basis of an if formula provide a certain label. Some how my formula give all blanks (orange part of the attached). I am not sure if the indirect address of the map formula works like this:

=LET(tbl;XLOOKUP(A2#&"|"&B1#;tbl_Data[Nummer]&"|"&tbl_Data[PostingDate];tbl_Data[Status];;0);
     MAP(tbl;LAMBDA(a;
        LET(b;INDIRECT(ADDRESS(ROW(a);COLUMN(a)));
            x;AND(OFFSET(b;;0)="Uitgebracht";ISERROR(OFFSET(b;;1)));
            y;AND(OFFSET(b;;1)="Opdracht";OFFSET(b;;0)="Uitgebracht");
            z;AND(ISERROR(OFFSET(b;;0));ISERROR(OFFSET(b;;1)));
            IFERROR(IFS(x;"Vervallen";y;"Nieuw";z;"");"")))))

Somebody any suggestion on this?

Many thanks, 

Resources