Forum Discussion
xlookup multiple values
[ Spoiler ]
=TEXTJOIN(",",,FILTER($E$1:$E$5,ISNUMBER(SEARCH($D$1:$D$5,A1))))
If you have access to TEXTJOIN and FILTER you can apply this formula.
- OliverScheurich Thank you!
=TEXTJOIN(",",,FILTER($E$1:$E$5,ISNUMBER(SEARCH($D$1:$D$5,A1))))
If you have access to TEXTJOIN and FILTER you can apply this formula.
