Stuck on simple formula.

[PACULA]

Could you some help, a co-worker and I have been stuck forever on this.

When the Location is the Jungle and the Country US AND the description is EITHER Tiger or Lion, return Animal. Otherwise, return column B (not found).

In the green section I can get Animal but the formula always returns FALSE if any of the conditions isn't true instead of not found.

Formula is below...what am I doing wrong?

=IF(AND(A2="Jungle",LEFT(D2,2)="US"),IF(ISNUMBER(SEARCH("Lion",N2)),"Animal",IF(AND(A2="Jungle",LEFT(D2,2)="US"),IF(ISNUMBER(SEARCH("Tiger",N2)),"Animal",IF(AND(A2="Jungle",LEFT(D2,2)="US"),B2)))))

 

[ebea]

I send a little example here:

Mappe1
	A	B	C	D	E	F
1
2
3	Dog	Cat	Dog	US22	Ways of the Dog Inc.
4		Cat	Cat	US22	ways of the Cat Inc.
5
6
Ark1

Cell Formulas
Range	Formula
C3:C4	C3	=IF(AND(A3="Dog",LEFT(D3,2)="US"),IF(ISNUMBER(SEARCH("Dog",E3)),"Dog",B3),B3)

 

[PACULA]

Oh, it might be the comma Dave. Give me a bit to test.

 

[ebea]

Ebea, I'm new to this board (as a poster, anyways) and hope that I'm ok in posting a link to my file on Google Drive. If I'm supposed to follow another process, happy to.

If you try to input the formula suggested, you'll see the error message/suggested correction. If the correction is made, it's still false. If the correction isn't made, the formula fails.

MREXCEL file

In you'r example, the B3 at the end of you'r Formula, are still missing. That's why you get the FALSE in return.

 

[PACULA]

Thanks Ebea. Yep, I left it out so you could see that the ; didn't work when added in. But that looks like the comma issue and is solved. I'm working through the implications and if the model will work now.

Either way, I'll check back in to either ask more questions for offer more thanks to you and Dave: ).