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

Similar Threads

How to make repeating drop-down lists? 2
Font drop-down menu very slow 0
Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Cross reference drop down not activating 1
drop down box code 2

Top