Calculate Value of Cell From Pick List Choice

B

Buz

I need a formula that will allow the automatic population of a cell or group
of cells based on selection from a user defined pick-list.

Example:

Pick List Value - Books
Clothes
Games

Account code for Books = 123
Clothes = 456
Games = 789

Product type? Account Code?
(From pick list) (automatically populated from
pick list)

Thanks,
 
Top