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