Forum Discussion

mtolli108's avatar
mtolli108
Copper Contributor
Mar 06, 2020

ISNUMBER Search for multiple query

I am new to excel and having problems changing a ISNUMBER Search to handle multiple words.

 

=ISNUMBER(SEARCH("P20",E8)) is working fine.

I want to add P20 or P04 would be true.

If I want to add a "P04"  how do I go about doing this.

=ISNUMBER(SEARCH({"P04","P20"},E8)) I tried this but it came up with a #Spill! error.

 

Thanks for the help

 

Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 06, 2020

    mtolli108 

    Such formula returns the spill with result for each value

    If there is no space to locate the spill, you have #SPILL! error.

    To return only one value with OR condition you may use

    =OR(ISNUMBER(SEARCH({"P04","P20"},E8)))

Resources