Hi!

An amateur question: can someone help me getting a good tutorial or the
neccesary information for filling row B automatically depending on the
data on row A?
For example:
If row A says:
Dog
Carrot
Apple
Orange
Cat
Horse

I would like row B to be automatically filled with:
animal
vegetable
fruit
fruit
animal
animal

* Notice that the order on A doesn't follow a pattern

Thanks!
SSJ