I can't seem to get the "OR" working:
What I would like to do is have
A1:A100 has a list of different animals
B1:B100 return a specific text string based on what it finds in A:A
C1:C100 are the quantities of the animal in B:B on the farm
D1:D?? are the text strings to search for in A:A, which will keep increasing over time.
Example:
A1= Furry brown sharp pointy toothed boar
D1 = dog
D2 = cat
D3 = bird
What I would like is for B1 to look at A1, see if any of D:D appear, if so then it returns "This is a safe pet!". If not, then it just returns A1. And so forth down the rows...
So in the case above
B1 = Furry brown sharp pointy toothed boar
Now if someone decides to add boars to the list of safe animals, so inputs a string in a new cell
D4 = boar
Then
B1 = This is a safe pet!
What I would like to do is have
A1:A100 has a list of different animals
B1:B100 return a specific text string based on what it finds in A:A
C1:C100 are the quantities of the animal in B:B on the farm
D1:D?? are the text strings to search for in A:A, which will keep increasing over time.
Example:
A1= Furry brown sharp pointy toothed boar
D1 = dog
D2 = cat
D3 = bird
What I would like is for B1 to look at A1, see if any of D:D appear, if so then it returns "This is a safe pet!". If not, then it just returns A1. And so forth down the rows...
So in the case above
B1 = Furry brown sharp pointy toothed boar
Now if someone decides to add boars to the list of safe animals, so inputs a string in a new cell
D4 = boar
Then
B1 = This is a safe pet!