Multiple nested if statements with the =IF(ISTEXT(SEARCH

[paintdrying]

So I just started cutting my teeth on some of the more complicated parts of Excel. I want to output one of a variety of text strings in a given cell based on a variety of text strings in a column to the the left. Some sort of fuzzy match would be excellent as well. I'm not using VBA either.

Practical example: output tiger ( in B5) every time Africa or India shows up in (A5), but also output horse of cow (in B5) whenever America or Europe show up in (A5).

Basically is would output a given text (of multiple possible) based on a a given text (of multiple) in the referencing cell .

<bdo dir="ltr">=IF(ISTEXT(SEARCH("Africa",A452)),A453,"lion") I believe this formula here will output lion whenever Africa Is put within the search. But how do I also say (within in the same cell) if the text happens to be America or Europe output cow </bdo>

 

[philwojo]

What do you mean it only works for the 1st value? You only asked to have it check for multiple instances of Africa and America, not India and Europe, so that is all it is doing.

 

[philwojo]

And I spelled Europe incorrectly in my formula, sorry that was a typo, but you can fix that part.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...-refrences-without-requiring-exact-match.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[paintdrying]

I will keep playing with it and see what comes out

 

[paintdrying]

ok sorry Mr. Excel. I actually didnt realise the two were connected one is mr. excell and the other is called excell forum

 

[Fluff]

They aren't connected. I suggest that you read this to understand https://www.excelguru.ca/content.php?184

 

[philwojo]

I will keep playing with it and see what comes out

If you can tell us what exactly isn't working for you, and what you need I'm sure it can be updated, just need more information to go on.