Hi
Is it possible to enter specific text based upon a list of options. For example
I have a table containing animals in column B as follows:
B2 - Owl
B3 - Elephant
B4 - Sparrow
B5 - Dolphin
B6 - Lion
B7 - Trout
B8 - Cat
B9 - Whale
B10 -Pigeon
etc
In column C I would like to enter the animal type. I would like the formula to do the following:
If B2 contains Owl, Sparrow or Pigeon then C2 is bird
If B2 contains Elephant, Lion, Cat then C2 is mammal
If B2 contains Whale, Dolphin, Trout then C2 is fish.
And so on and so forth for each cell.
I don't want to use lookups if at all possible.
I hope this makes sense.
Thanks for the help.
Bookmarks