How do I create a drop down box within a drop down box?

S

sg

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top