Forum Discussion

Copper Contributor

Jul 31, 2021

Populate dynamic list of row or column items based on table value.

Hi everyone, I am trying to generate two lists based on a "y" or "n" value in the table. The image above shows my desired result in red box. any help would be great.

Silver Contributor

Oct 19, 2022

Hi joshua935

Alternatively in H4

=FILTER(B5:B8, XLOOKUP(H3, C4:E4, C5:E8, 0) = "y", "No match")

in J4

=TRANSPOSE(FILTER(C4:E4, XLOOKUP(J3, B5:B8, C5:E8, 0) = "y", "No match"))

Re. it isn't working if C4, D4, E4 contains date value No good reason: