| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 values in 1 cell
Hello All,
I'm trying to make a drop down list with alpha values (A thru Z) so that if you select "A", it'll show "A" in the cell but give it a value of 1. Thus if you select "B" in the dropdown, it'll show "B" however give it a value of 2 and so on. Anyone have a VBA macro or excel equation that would work for this? Corey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Copy values from a cell based on values of another cell | Excel Discussion (Misc queries) | |||
| How to assign values to a cell based on values in another cell? | Excel Worksheet Functions | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
Threaded Mode
