Forum Discussion
Help with IF and (ISNUMBER(SEARCH
Hello! I was wondering if you guys could help me with a complex problem using IF and pieces of text. Below formula: =IF(AND(J21519=ISNUMBER(SEARCH("PILOT",J21519)),OR(Q21519=ISNUMBER(SEARCH("M...
SEARCH("PILOT",J21519) returns position of "PILOT" in text or error if nothing is found
ISNUMBER(SEARCH("PILOT",J21519)) returns TRUE or FALSE depends on was "PILOT" found or not
J21519=ISNUMBER(SEARCH("PILOT",J21519) means
=(J21519=TRUE) or =(J21519=FALSE) which always returns FALSE since in J21519 you have some text, not Boolean value.
Thus simply use ISNUMBER(SEARCH("PILOT",J21519) as condition.