Dependent Drop Down List

[Micah Lee]

I am trying to create an order form for my company where there are different options depending on which item is selected.
Say I want to order a cedar 2x4 as opposed to a different kind of 2x4. Cedar only comes in certain sizes and I want my next drop down to only show those sizes. I have followed tutorials online and I keep running into the same problem. I create name ranges first and then set my first drop down box. But then, when I go to set the dependent box there is an error message which says "The Source currently evaluates to an error." This is where I am stuck. Any help?

 

[kweaver]

Here's a very good write-up on the process:

Dependent Drop Down

 

[Micah Lee]

Here's a very good write-up on the process:

Dependent Drop Down

Thank you. Still not working. I must be doing something wrong.