| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a drop down box within a drop down box?
I am trying to create a drop down box that shows a list of main material
types and a second drop down box that will pick up a range of material based on the choice in the lst drop down. My first data validation cell is set to the main material type range I tried a nested if function and have too many (I have 9) I tried to enter the following in a neighboring cell (b1) =vlookup(a1,range of sublist,column,false) to pick the appropriate sublist Then I entered my second drop down list and the data validation I used was =concatenate(b1&"_range") I get a message that says "The list source must be a delimited list, or a reference to a single row or column" The range is a single column so I am not sure how to proceed. Any suggestions on how to accomplish this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
| how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
Threaded Mode
