Reverse-Filter-List-of-Items-Partial-Match (ADVICE)

[VBA learner ITG]

Hi Peers,

I hope you are well?

I need your help if possible as I have tried trusted google and I am unable to amend the formula to do what i need.

The formula currently works by doing a partial word match when it finds one value in the table.

I need your help to amend the formula so where it finds multiple words it populates it all in the same cell.

For Example output:

POS/Fixtures/Marketing/Digital Assets/Photography/John Lewis/Ocado/Currys/Dobbies/Waitrose/Lakeland/Next/Costco/QVC/Amazon

=IFERROR(LOOKUP(1E+100,SEARCH(tblFilterList[Filter List],[@Name]),tblFilterList[Filter List]),"")

 

[Fluff]

Maybe

=TEXTJOIN("/",,IF(ISNUMBER(SEARCH(tblFilterList[Filter List],[@Name])),tblFilterList[Filter List],""))

 

[VBA learner ITG]

Maybe

=TEXTJOIN("/",,IF(ISNUMBER(SEARCH(tblFilterList[Filter List],[@Name])),tblFilterList[Filter List],""))

Hi Fluff,

Thank you for taking the time to reply and your revised formula solution did the trick.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[rodrigobertollo]

Hi @Fluff I need help with your solution I need the inverted search. One line with all the info that can be will be search in each row (example in the image)

Can this be doable?

Thanks

 

[Fluff]

Please start a thread of your own for this question. Thanks

 

[rodrigobertollo]

Please start a thread of your own for this question. Thanks

Sorry! Just did it.
Thanks for the advice.