changing cell information depending on another cell

please help - I am doing a rostering spreadsheet.
sorry if I don't explain it well what I would like to do.

1. I would like to put a person's name ( andrew, tim etc ) in a particular cell (eg. A1 )
2. Depending on the name placed into A1 I would like another cell (eg. C2) to have automatically have placed another word (eg. cleaning, restocking, etc )

Is this a macro visual basic, I am not verse with this, could some-one help

many thanks

andrewm

I do not think it is a vlookup

in A1 - if i type in say andrew then a2 automatically goes to inventry
if i type in say john then a2 automatically goes to cleaning

is this countif or is it vlookup

andrewm

Try and see if the enclosed file works. Otherwise I don't understand what you mean by "a2 automatically goes to cleaning".

Ola Sandström

Hi sorry for not making it clear

I would like to type a name in cell A2, this will automatically place a word in another cell (A2) depending what name is in cell A2.

thus -

if i type in A1 - "andrew" this will automatically put the work "cleaning in cell A2
if i type in A1 - "john" this will automatically put the word "cleaning" in cell A2

thanks andrewm