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

Question

&nbsp;&nbsp;&nbsp;Hi everyone,&nbsp;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.

subodh_tiwari_sktneer · Answer

joshua935&nbsp;Maybe this...&nbsp;In H4=SORT(FILTER(B5:B8,INDEX(C5:E8,,MATCH(H$3,$C$4:$E$4,0))="y"))&nbsp;In J4=SORT(TRANSPOSE(FILTER(C4:E4,INDEX(C5:E8,MATCH(J$3,$B$5:$B$8,0),)="y")))&nbsp;&nbsp;

mehul2011 · Answer

Subodh_Tiwari_sktneer&nbsp;Thank you so much for sharing the formula.&nbsp;However, for me it isn't working if C4, D4, E4 contains date value.&nbsp;How do I convert date or do I have to try different formula at H4 and J4?&nbsp;Thanks.

lorenzo · Answer

Hi&nbsp;joshua935&nbsp;&nbsp;Alternatively in&nbsp;H4=FILTER(B5:B8, XLOOKUP(H3, C4:E4, C5:E8, 0) = "y", "No match")in&nbsp;J4=TRANSPOSE(FILTER(C4:E4, XLOOKUP(J3, B5:B8, C5:E8, 0) = "y", "No match"))&nbsp;Re. it isn't working if C4, D4, E4 contains date value No good reason:&nbsp;

Forum Discussion

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

Share

Resources