| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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, |
|
#2
|
|||
|
|||
|
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, . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
| Pick list | Excel Discussion (Misc queries) | |||
| cell reference to last item in a list | Excel Discussion (Misc queries) | |||
| right click option "pick from a list" | New Users to Excel | |||
| Removing a drop down list from a cell | Excel Discussion (Misc queries) | |||
Linear Mode
