Can FILTER return full rows that meet 2 Criteria?

[c.clavin]

Hi guys, I thought I had this working, but it's only returning results for the first criteria, not the 2 I have in my formula:

=FILTER(ENTRYTABLE,(ISNUMBER(SEARCH(Sheet1!$AE$3,'DATATABLE'!M2:M41) * (ISNUMBER(SEARCH(Sheet1!$AC$3,'DATATABLE'!M2:M41))))))

Is there something I'm doing wrong? I thought by putting the * multiplier in there it would return only rows that meet both criteria. I flipped the formula and it only found those results in the first part of the formula. Any help would be appreciated, I'm really confused. Thanks all!

 

[Fluff]

You have the brackets in the wrong place, try

=FILTER(ENTRYTABLE,(ISNUMBER(SEARCH(Sheet1!$AE$3,DATATABLE!M2:M41)))*(ISNUMBER(SEARCH(Sheet1!$AC$3,DATATABLE!M2:M41))))

 

[c.clavin]

Fluff, you are a LEGEND! Thank you so much!! I was beating my head against the wall, time to ice down haha!

 

[Fluff]

Glad to help & thanks for the feedback.