Forum Discussion
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 ...
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)))