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
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