| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation List - Can I have multiple ranges displayed?
I am using Excel 2007.
I have two named ranges: Customer_ID and Customer_Name. I currently have a data validation list with the source '=Customer_ID'. This works fine to look up customer numbers or I can change the source to 'Customer_Name' and look up by name. At some times it's easier to lookup by name, and others by number. Is it possible to have the drop down list display both? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation list from Named Ranges | Excel Worksheet Functions | |||
| Data validation: concatenate two separate ranges in the List? | Excel Discussion (Misc queries) | |||
| Creating a list (data validation) fromt wo different source ranges | Excel Discussion (Misc queries) | |||
| Data validation using multiple ranges | Excel Discussion (Misc queries) | |||
| data validation--multiple dependent list | Excel Discussion (Misc queries) | |||
Threaded Mode
