Hello gurus,

I'm trying to build a list in which I have column B where I can select from approximately 10 items in an in-cell drop-down list (got that figured out with data validation), and then I want to have another in-cell drop-down list in column C, whose values will be restricted to sub-items based on whatever was selected in column B.

Does that make sense? Is it doable? And if so, how?

Thanks much for any help you can offer!