CODEWITHSUNDEEP
excelexcel-formula
snookian
snookian

Reputation: 873

Searching for word and displaying data with a filter

I use a formula that looks up a word in B1 of one worksheet and displays all the results that have that word from anouther: =FILTER('Supplier Merged'!$A$2:$N$20,'Supplier Merged'!$G$2:$G$20=$B$1,"")

This works great apart from it looks up what I have assigned for a catergory, so for example I select 'Book' from B1 and it shows all results that have the category 'Book'. It only works if the one phrase is exact.

I want to adjust this so that I can search for a term, IE type 'Wizards' into B1 and it will display results that have the word Wizards even if the phrase is longer, for example 'A book on Wizards'

Upvotes: 0

Views: 32

Answers (1)

Rory
Rory

Reputation: 34035

You can use something like this:

=FILTER('Supplier Merged'!$A$2:$N$20,ISNUMBER(SEARCH($B$1,'Supplier Merged'!$G$2:$G$20)),"")

Upvotes: 2

Related Questions