Calculate Value of Cell From Pick List Choice
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,
|