SEARCH for multiple words

[Nanaia]

I'm trying to search cells for certain letter combinations and seem to have forgotten how. I want to look at cell H3 on another sheet for code "WJ" and/or "SP" and come back with TRUE for true and blank for false. The only time it should be false is if neither WJ or SP are in the cell. The formula I have will come back with a true if WJ is in the cell but won't return a true if SP is in the cell and I'm trying to figure out why. Can anyone help?

My formula is, [=IF(ISNUMBER(SEARCH({"WJ","SP"},'OPF P4'!H3)),TRUE,"")]

 

[steve the fish]

Wrap the ISNUMBER with an OR. =IF(OR(ISNUMBER etc.

 

[Nanaia]

Thank you!