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

VBA learner ITG

Board Regular
Joined
Apr 18, 2017
Messages
218
Office Version
  1. 365
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]),"")
 

Attachments

  • PARTIAL WORD IMAGE.JPG
    PARTIAL WORD IMAGE.JPG
    241.1 KB · Views: 5

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
58,135
Office Version
  1. 365
Platform
  1. Windows
Maybe
Excel Formula:
=TEXTJOIN("/",,IF(ISNUMBER(SEARCH(tblFilterList[Filter List],[@Name])),tblFilterList[Filter List],""))
 
Solution

VBA learner ITG

Board Regular
Joined
Apr 18, 2017
Messages
218
Office Version
  1. 365
Maybe
Excel Formula:
=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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
58,135
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

rodrigobertollo

New Member
Joined
May 27, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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)
1622153176512.png


Can this be doable?

Thanks
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
58,135
Office Version
  1. 365
Platform
  1. Windows
Please start a thread of your own for this question. Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,132,644
Messages
5,654,552
Members
418,140
Latest member
ahepple86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top