| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dropdown list to return different value
Hello,
Does anyone know how I can make a dropdown list in Excel return a value that is not necessarily in the list? Example - the list would include city names and possibly the corresponding code, but I would like it to return only the corresponding three digit "code". Langdon City = 292 Munich City = 396 Hannah City = 442 I am assuming this is not possible just using the Data Validation feature in Excel, and I am more than willing to try it via VB, but I'm not familiar enough with the code to know where to start! Any help would be greatly appreciated! Tanya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return value from a dropdown list in other cell | Excel Discussion (Misc queries) | |||
| select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Threaded Mode
