Conditional Data Validation

[KJSherman]

I have a workbook with two worksheets. The first tab is a request form for users to fill out and the second is the drop-down values.

I would like the drop-down values to change based on the value they select in column A.

In A2, they can select from 3 values (the drop down is based on a data validation list called Brand) I want column D drop-downs to populate based on the value they select in column A. I separated out all the data on tab 2, so depending on what they select in A2, they would either need to lookup to Column E or F on the second tab.

I have other similar conditional scenarios but just need helping getting started on the first one! Should I be setting up my lookup data in a different format to make this easier?

[#2]

@KJSherman 

See Create Dependent Drop Down Lists for clear instructions, with a video, a downloadable sample workbook and links to more advanced examples.

[#3]

@Hans Vogelaar thank you, this was very straightforward and much easier than what I was trying on my own!