If Statement Based on Text Help!!

**igor4273** · 07-08-2012, 03:47 PM

Hello,

Is there a way to string multiple IF statements based on text?
For example, I used this formula =IF(ISNUMBER(SEARCH("dog",A1)),"dog","")
This works for only one of them but what if I wanted it to look for "cat" in A1 and "mouse" in A1 as well and write the corresponding word in another column? (there is no way it could have two out of the three words in the same row, if that is important)

I've been trying to string it together like this but I keep getting a "#VALUE" error
=IF(ISNUMBER(SEARCH("dog",A1)),"dog",""),IF(ISNUMBER(SEARCH("cat",A1)),"cat","",IF(ISNUMBER(SEARCH("mouse",A1)),"mouse","")

Thank you very much if you can contribute any kind of help!!

**Bob Phillips** · 07-08-2012, 03:54 PM

Is this what you mean?

=IF(ISNUMBER(SEARCH("dog",A1)),"dog","")
&IF(ISNUMBER(SEARCH("cat",A1)),"cat","")
&IF(ISNUMBER(SEARCH(" mouse",A1)),"mouse","")

**xladept** · 07-08-2012, 03:55 PM

Yes, you can do that but the "ISNUMBER" is unnecessary:

Please Login or Register  to view this content.

**igor4273** · 07-08-2012, 04:08 PM

Originally Posted by Bob Phillips

Is this what you mean?

=IF(ISNUMBER(SEARCH("dog",A1)),"dog","")
&IF(ISNUMBER(SEARCH("cat",A1)),"cat","")
&IF(ISNUMBER(SEARCH(" mouse",A1)),"mouse","")

Hmm, for some reason when I try this, I just get a blank cell...

**igor4273** · 07-08-2012, 04:10 PM

Originally Posted by Bob Phillips

Is this what you mean?

=IF(ISNUMBER(SEARCH("dog",A1)),"dog","")
&IF(ISNUMBER(SEARCH("cat",A1)),"cat","")
&IF(ISNUMBER(SEARCH(" mouse",A1)),"mouse","")

wait!! nevermind! that solved it!! thank you very much!!