You need the Vlookup function for this.

Check out the Excel pages at www.nwarwick.co.uk where you will find a link
to an easy to follow tutorial that you can adapt to your own situation.

HTH

Neil
www.nwarwick.co.uk


"SEOJAPAN" wrote:

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