xlookup multiple values

Question

Spoiler (Highlight to read)Hello I am trying to use a column where each cell has multiple Unique Identifiers separated by a column. in another sheet there's a column where each cell has a singular unique Identifier. I am trying to pull the products associated with the singular identifiers and bring each unique product separated by commas, into another column. I did it manually for example below. I think it should be some sort of xlookup but I can't figure it out. I need a forumla to give me column b.&nbsp;Hello I am trying to use a column where each cell has multiple Unique Identifiers separated by a column. in another sheet there's a column where each cell has a singular unique Identifier. I am trying to pull the products associated with the singular identifiers and bring each unique product separated by commas, into another column. I did it manually for example below. I think it should be some sort of xlookup but I can't figure it out. I need a forumla to give me column b.&nbsp;

oliverscheurich · Answer

seandillon&nbsp;=TEXTJOIN(",",,FILTER($E$1:$E$5,ISNUMBER(SEARCH($D$1:$D$5,A1))))&nbsp;If you have access to TEXTJOIN and FILTER you can apply this formula.&nbsp;

seandillon · Answer

OliverScheurich Thank you!

Forum Discussion

xlookup multiple values

2 Replies