Forum Discussion
MichielS340
May 14, 2025Copper Contributor
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,
1 Reply
Sort By