Function Argument logic and if statements

[Jenn1981]

Hi Everyone,

I am so stuck.
Im trying to write a formula that will look in Column C for certain words.

For example, If column C has the work Kick. Have the word kick in Column A.
or
If Column C has the word rain, Have the word rain in Column A.
or
If Column C has the word storm, Have the word storm in Column A.
or
anything else show NA.

I tried 2 different ways below and im very close but cant solve this.

=OR(IF(ISERROR(SEARCH({"*kick*","*rain*","*storm*"},C2)),FALSE,TRUE))

=IF((COUNTIF(C2, "*kick*") + COUNTIF(C2, "*rain*") + COUNTIF(C2, "*storm*")), TRUE, FALSE)

Thank you so much,
Jenn

 

[AliGW]

What is wrong with the second one? What are your expected results?

 

[Jenn1981]

Hi AliG,

Both formulas are doing the same thing. But this is not what im trying to do.
Please the image below of what im trying to do.

Im trying to write a formula that will look in Column C for certain words.
For example, If column C has the work Kick. Have the word kick in Column A.
or
If Column C has the word rain, Have the word rain in Column A.
or
If Column C has the word storm, Have the word storm in Column A.
or
anything else show NA.

 

[Nebu]

Hi:

Use this formula

=IFERROR(LOOKUP(2^15,SEARCH($F$1:$F$3,C2),$F$1:$F$3),"")

Thanks

 

[Jenn1981]

Thank you Nebu. you are the best.

 

[Jenn1981]

Hi:

Use this formula

=IFERROR(LOOKUP(2^15,SEARCH($F$1:$F$3,C2),$F$1:$F$3),"")

Thanks

Hi Nebu,
what if I wanted to say instead of Inserting the word rain I would like to insert the word "best". for Storm, I would like to insert the word "better".
I have the screen shot below and added it also to the excel file.

 

[NARAYANK991]

Hi ,

Try changing the formula to :

=IFERROR(LOOKUP(2^15,SEARCH($F$1:$F$3,C2),$G$1:$G$3),"")

Narayan

 

[Jenn1981]

thank you. you are so smart.