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?

Hi,
Look into Debra web

http://www.contextures.com/xlDataVal02.html

"sg" wrote:

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?