Here are my corrected formulas:
Available rooms:
Please try
=LET(
f,FILTER(Database!B2:U88,ISNUMBER(XMATCH(Database!A2:A88,B4:J4))),
t,VSTACK(Database!B1:U1,f),
u,FILTER(t,BYCOL(t,LAMBDA(c,ISNA(XMATCH("No",c))))),
r,TAKE(u,1),
z,TRANSPOSE(FILTER(r,r<>0)),
IFERROR(MAP(z,LAMBDA(x,LET(q,UNIQUE(INDEX(u,,1+XMATCH(x,r))),TEXTJOIN(" , ",,x,XLOOKUP(FILTER(q,q<>"",""),Database!X4:X14,Database!Y4:Y14,""))))),"No rooms available"))
Special requirements:
Please try:
=LET(
f,FILTER(INDEX(Database!V2:W88,,XMATCH(D17,Database!V1:W1)),ISNUMBER(XMATCH(Database!A2:A88,B4:J4))),
IFERROR(MAP(SORT(UNIQUE(TEXTSPLIT(TEXTJOIN(", ",,f),,", "))),LAMBDA(x,x&": "&XLOOKUP(x,'Special Requirements Database'!A2:A99,'Special Requirements Database'!B2:B99))),"-"))
Bookmarks