Use VLOOKUP. For examples, see:

http://www.contextures.com/xlFunctions02.html
http://www.techonthenet.com/excel/formulas/vlookup.htm

HTH
Jason
Atlanta, Ga

-----Original Message-----
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,
.