I am trying to create a column that reads from a cell with a long
string of text. For example: PPC: Intro to World Studies 2003 TRP
Assembly. I've tried using if statements and vlookups to extract "TRP"
from the sentence, I did this using:
=if(isna(match("*TRP*",F2,0),"Medium","Other").

How can I create a fromula that allows me to use multiple conditions?
For example, if the cell contains "Cat", "Dog", "Bird," = animal?

Thanks

=IF(ISNUMBER(SEARCH("*TRP*",F2)),"Medium","Other")


" wrote:

I am trying to create a column that reads from a cell with a long
string of text. For example: PPC: Intro to World Studies 2003 TRP
Assembly. I've tried using if statements and vlookups to extract "TRP"
from the sentence, I did this using:
=if(isna(match("*TRP*",F2,0),"Medium","Other").

How can I create a fromula that allows me to use multiple conditions?
For example, if the cell contains "Cat", "Dog", "Bird," = animal?

Thanks

One way:
=IF(SUM(COUNTIF(F2,{"*cat*","*dog*","*bird*"}))=0, "Medium","Other")
or
=IF(SUM(COUNTIF(F2,"*"&{"cat","dog","bird"}&"*"))= 0,"Medium","Other")



wrote:

I am trying to create a column that reads from a cell with a long
string of text. For example: PPC: Intro to World Studies 2003 TRP
Assembly. I've tried using if statements and vlookups to extract "TRP"
from the sentence, I did this using:
=if(isna(match("*TRP*",F2,0),"Medium","Other").

How can I create a fromula that allows me to use multiple conditions?
For example, if the cell contains "Cat", "Dog", "Bird," = animal?

Thanks

--

Dave Peterson

Thank you , thank you!

Cheers!


Dave Peterson wrote:
One way:
=IF(SUM(COUNTIF(F2,{"*cat*","*dog*","*bird*"}))=0, "Medium","Other")
or
=IF(SUM(COUNTIF(F2,"*"&{"cat","dog","bird"}&"*"))= 0,"Medium","Other")



wrote:

I am trying to create a column that reads from a cell with a long
string of text. For example: PPC: Intro to World Studies 2003 TRP
Assembly. I've tried using if statements and vlookups to extract "TRP"
from the sentence, I did this using:
=if(isna(match("*TRP*",F2,0),"Medium","Other").

How can I create a fromula that allows me to use multiple conditions?
For example, if the cell contains "Cat", "Dog", "Bird," = animal?

Thanks

--

Dave Peterson