Searching for multiple text

[Austin Lang]

Hello all,

I am trying to create a report that shows all cleaning failures over the course of a month. Failures are called both "Failed" and "Aborted". The formula I have been using works well for Failed. However, I need to be able to search for both of those terms. Everything I have found says that I can add an OR function to search multiple, but it doesn't return anything when i add it. What am I missing here? Is it the Filter function causing my issue?

The original working formula:
=IFERROR(FILTER(Form!$A$5:$X$3001,ISNUMBER(SEARCH("Failed",Form!C5:C3001))),"")

Thanks in advance,

 

[hagia_sofia]

Hello, try:

=IFERROR(FILTER(Form!$A$5:$X$3001,(ISNUMBER(SEARCH("Failed",Form!C5:C3001)))+(ISNUMBER(SEARCH("Aborted",Form!C5:C3001)))),"")

 

[SunnyAlv]

try like this

=IFERROR(FILTER(Form!$A$5:$X$3001,(Form!C5:C3001="Failed")+(Form!C5:C3001="Aborted")),"")

 

[Austin Lang]

Hello, try:

=IFERROR(FILTER(Form!$A$5:$X$3001,(ISNUMBER(SEARCH("Failed",Form!C5:C3001)))+(ISNUMBER(SEARCH("Aborted",Form!C5:C3001)))),"")

This one worked flawlessly. Thank you so much.