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, |
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, . |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com