Filter Function with multiple conditions does not work

[lupus9]

Hey guys,

I need help with my formula:

=FILTER(TDB,(ISNUMBER(SEARCH(F8,TDB[Fund Manager])))+(ISNUMBER(SEARCH(F8,TDB[Description])))+(ISNUMBER(SEARCH(F8,TDB[Tags])))
*(ISNUMBER(SEARCH(F19,TDB[Verticals]))),"Not Found")

When I added the part in bold, the formula ignores it.

What I try to accomplish:
(TDB is the name of a table I created)
F8 and F19 are input cells where I want to search with. F8 as general search function in 3 columns: Fund Manager, Description and Tags
F19 is supposed to be the cell for searching industry sectors (Verticals).

What does not seem to work is the * at the beginning of the bolded part which is supposed to translate with "and".
I want to search the 3 columns with F8 ("or" -> "+") and the the column Verticals ("and" -> "*"), so: Fund Manager OR Description OR Tags AND Verticals

Why does "*" not work? Please help.

Thank you in advance!

 

[Fluff]

Hi & welcome to MrExcel.
When mixing or & And you need to wrap the criteria in extra brackets like

=FILTER(TDB,((ISNUMBER(SEARCH(F8,TDB[Fund Manager])))+(ISNUMBER(SEARCH(F8,TDB[Description])))+(ISNUMBER(SEARCH(F8,TDB[Tags]))))*(ISNUMBER(SEARCH(F19,TDB[Verticals]))),"Not Found")