Auto generate value

Hi Guys,

I wasn't sure where my question belongs so i've put it in the general forum.

I have a spreadsheet with a lot of info on it. One of the Columns is titled category, each category falls under the title of one of four things (North, South, East & West) what i'm trying to do is set up excel so that whenever i type in a value in the category column, a title of NSEW will automatically appear in a seperate column. Can anybody tell me if this is possible to do in excel and give me some info on the best way to go about it?

Any help is greatly appreciated.

Thanks