| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation List - Dependant based on numeric values
Hi:
I have two columns as follows: Dept Brand 2 Hanes, Leggs 8 Converse, Aerosoles 12 Levi's, Dockers When the user selects the dept # in col A, I want it to restrict the drop-down in Col B to only show the applicable brands. Problem is I can't use the typical Indirect formula method because it won't allow me to name the cell with a number. Can you offer an alternative? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation dependant drop down on unsorted list | Excel Worksheet Functions | |||
| Display part of list dependant on Validation list selection | Excel Worksheet Functions | |||
| validation list or combo box dependant on cell value | Excel Worksheet Functions | |||
| Cross Dependant Validation List | Excel Discussion (Misc queries) | |||
| Dependant Data Validation List | Excel Discussion (Misc queries) | |||
Threaded Mode
