Filter function with multiple and|or criteria not working

[JesusPM]

Hi experts,
I'm having some issues when trying to create complex FILTER function criterias using AND plus OR.
They are working separately, but when I add two OR criterias it returns all of them (it should only select the light blue ones anbd NOT the yellow ones). The final formula will contain more ORs, so I wonder if using an array under search will work, becuase I have not managed to get it working on my side.
Here the function I use in F5, and the table:

=TEXTJOIN("#",TRUE,FILTER(B:B,(D:D=G2)*((ISNUMBER(SEARCH("Meraki",C:C))=FALSE)+(ISNUMBER(SEARCH("Voice",C:C))=FALSE)),""))

 

[Phuoc]

Try change + to * :

=TEXTJOIN("#",TRUE,FILTER(B:B,(D:D=G2)*((ISNUMBER(SEARCH("Meraki",C:C))=FALSE)*(ISNUMBER(SEARCH("Voice",C:C))=FALSE)),""))

 

[Fluff]

Hi & welcome to MrExcel.
Another option is

=TEXTJOIN("#",TRUE,FILTER(B:B,(D:D=G2)*(ISERROR(SEARCH("Meraki",C:C)))*(ISERROR(SEARCH("Voice",C:C))),""))

As you are using not equals it needs to be And rather than Or

 

[Peter_SSs]

I would avoid using whole column references (unless you have upwards of one million rows of data).
At least with my Excel I can see the delay after entering any of those formulas before the result is displayed.

The final formula will contain more ORs

Depends how many more but assuming that just means more words to exclude a structure like this might appeal a bit more as it would not grow in length as much - just add more values in the {...} array

=TEXTJOIN("#",1,BYROW(B2:D10000,LAMBDA(r,IF((COUNT(SEARCH({"Meraki","Voice"},INDEX(r,2)))=0)*(INDEX(r,3)=G2),INDEX(r,1),""))))