| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating a Cell by Choosing from a Pick list in another Cell
I have a workbook with multiple sheets. In sheet 1 I have created a drop down
list referencing a range on sheet 3. The range referenced are codes for longer descriptions. I want to select the code from the drop down and have the description appear in another cell. Unfortunately there are duplicate codes with different discriptions. So there may be three AAA codes but each with a different adjacent description. I would be fine if this were backward. Where I select the description and the code appears in the other cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Pick List associated cell | Excel Discussion (Misc queries) | |||
| pick from list and automatically enter corresponding cell | Excel Programming | |||
| How do I populate an entire row by choosing one cell from a list | Excel Discussion (Misc queries) | |||
| how do i get a drop down pick list in a cell | Excel Worksheet Functions | |||
| how do i get a drop down pick list in a cell | Excel Worksheet Functions | |||
Threaded Mode
