Forum Discussion

shekharreddy's avatar
shekharreddy
Copper Contributor
Apr 01, 2020

how to search a list of items in a cell

Hello,

I am working for a project in this I need to match the correct industry to a brand,

 

Example: 

A                     B    

Amazon    Online Market   

 

Microsoft  IT & Software 

 

So in the column B has industry names and I have all the list . My requirement is when ever I search with the name like online it should display Online related all industries ... 

I tried Drop down but it;s not working.

 

Please suggest-Thank you!

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 02, 2020

    shekharreddy Perhaps the new FILTER function (should be available to most Office365 subscribers by now) will help out. An example is given in the attached workbook.

    Just type a keyword (or part of it) in D2 and all Industries that contain the keyword are listed in E.