| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use word to associate an item in validation drop down list
I have created a validation drop down list but because the list can be quite
long I want to be able to type a specific word on the cell that would associate that specific item in the drop down list. For example, lets say my drop down list contains the months of the year from January to December. I want to associate 1 = January and 2 = February and so on so that when I enter 6, June comes up on the cell. Does anyone know if this is possible on Excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add item to a drop-down list | Excel Discussion (Misc queries) | |||
| How do I add an item with comma in the list of data validation | Excel Discussion (Misc queries) | |||
| ADD ITEM TO A DROP DOWN LIST? | Excel Discussion (Misc queries) | |||
| Autoshow whole word when typing one item in the data validation bo | Excel Worksheet Functions | |||
| drop down list/typing item from list error | Excel Worksheet Functions | |||
Threaded Mode
