I'm currently using the formula below to return the value in C4 if the text in K4 "contains the phrase" "BRANCH DEPOSIT" anywhere in the string.
I need to expand the formula to also return the C4 value if it finds "BRANCH DEPOSIT" OR "TRSF" anywhere in the K4 text string.
I have not been successful at adding the second condition.
= IF(COUNTIF(K4,"*BRANCH DEPOSIT*"),C4,"")
Thanks in advance.
K
I need to expand the formula to also return the C4 value if it finds "BRANCH DEPOSIT" OR "TRSF" anywhere in the K4 text string.
I have not been successful at adding the second condition.
= IF(COUNTIF(K4,"*BRANCH DEPOSIT*"),C4,"")
Thanks in advance.
K