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...
excel
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.