Excel: CONCATENATE search question


Hello all, I am trying to create a Concatenate formula that searches a cell for "PHRASE" or "PHRASE 2". If either phrase exist than the output is 43. Can someone show me what this formula would look like? It cant be two different if statements like

=CONCATENATE(IF(ISNUMBER(SEARCH("PHRASE",H2)),"43","")&IF(ISNUMBER(SEARCH("PHRASE 2",H2)),",43",""))
This will give me 43,43 I am looking for something like
=CONCATENATE(IF(ISNUMBER(SEARCH("PHRASE" OR "PHRASE 2",H2)),"43",""))
Is this possible?


This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of June 20, 2014.


For more resources for Microsoft Excel