| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate Value on new cell based on List
Hi Excel Gurus,
How do I calculate a value on a new cell based on what the user selects from a List. For Example : If I have a dropdown List of 5 items - APPLE, ORANGE, BANANA, GRAPES, PINEAPPLE Selecting APPLE should paste a value 1 in the adjoining cell Selecting ORANGE should paste a value 2 in the adjoining cell Selecting BANANA should paste a value 3 in the adjoining cell Selecting GRAPES should paste a value 4 in the adjoining cell Selecting PINEAPPLE should paste a value 5 in the adjoining cell Thanks for your time. Warm Regards, Ranjit S Hans |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the number of weeksdays based on a cell value | Excel Worksheet Functions | |||
| IF statement to calculate based on cell values | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
| Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) | |||
Threaded Mode
