CONCATENATE search question

[wonderd]

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?

 

[XOR LX]

Thanks but honestly its to complicates for me to keep track of.

So what was the point in this post, then, for which my formula gives the required results?

I am looking for

1. if H2 contains either Phrase 1 or phrase 2 in any case format the answer is 43
2. if H2 contains either Phrase 3 or phrase 4 in any case format the answer is 50
3. if H2 contains BOTH Phrase 1 or phrase 2 and phrase 3 or phrase 4 in any case format the answer is 43,50

 

[wonderd]

I explained why I cant use it, I also gave an example of the type of formula I'm looking for. If its not possible using the type of fomula I gave then I will have to improvise. Thank you for giving a solution but I should have been more specific.

 

[XOR LX]

I explained why I cant use it, I also gave an example of the type of formula I'm looking for. If its not possible using the type of fomula I gave then I will have to improvise. Thank you for giving a solution but I should have been more specific.

Forgive me, but why are you restricted to a certain "type" of formula, may I ask? And if, as you say, it's not possible using the type of formula you want, would your "improvisation" not extend to considering other types?

Regards

 

[Michael M]

Did you try one of the solutions in the other post ???


http://www.mrexcel.com/forum/excel-questions/785859-concatenate-comma-question.html

 

[wonderd]

Sorry did not know that got any posts let me check it.

 

[XOR LX]

Did you try one of the solutions in the other post ???

http://www.mrexcel.com/forum/excel-questions/785859-concatenate-comma-question.html

This is double-posted as well?!?

 

[Michael M]

I still think a UDF or code would be a far better solution !!...love the posting..