Forum Discussion
Index Match: search for a string and return multiple values
I'm looking to do a lookup, and I assume index match is the rout to go, but I'm not certain. The lookup value will always be a single line, but the column I'm searching for a match on may have multip...
Zexall This one might work for you:
=TEXTJOIN(CHAR(10),TRUE,FILTER(B2:B30,ISNUMBER(SEARCH("*"&D2&"*",A2:A30)),"-"))
Enter it in E2 and copy it down. Make sure to have "Wrap text" activated where this formula resides.
EDIT: Forget about the wild-cards "*". This will work as well:
=TEXTJOIN(CHAR(10),TRUE,FILTER(B2:B30,ISNUMBER(SEARCH(D2,A2:A30)),"-"))
