Conditional Data Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1862693%22%20slang%3D%22en-US%22%3EConditional%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862693%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20two%20worksheets.%20The%20first%20tab%20is%20a%20request%20form%20for%20users%20to%20fill%20out%20and%20the%20second%20is%20the%20drop-down%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20the%20drop-down%20values%20to%20change%20based%20on%20the%20value%20they%20select%20in%20column%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20A2%2C%20they%20can%20select%20from%203%20values%20(the%20drop%20down%20is%20based%20on%20a%20data%20validation%20list%20called%20Brand)%20I%20want%20column%20D%20drop-downs%20to%20populate%20based%20on%20the%20value%20they%20select%20in%20column%20A.%20I%20separated%20out%20all%20the%20data%20on%20tab%202%2C%20so%20depending%20on%20what%20they%20select%20in%20A2%2C%20they%20would%20either%20need%20to%20lookup%20to%20Column%20E%20or%20F%20on%20the%20second%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20other%20similar%20conditional%20scenarios%20but%20just%20need%20helping%20getting%20started%20on%20the%20first%20one!%20Should%20I%20be%20setting%20up%20my%20lookup%20data%20in%20a%20different%20format%20to%20make%20this%20easier%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1862693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862755%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862755%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860589%22%20target%3D%22_blank%22%3E%40KJSherman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fxldataval02.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%20Dependent%20Drop%20Down%20Lists%3C%2FA%3E%20for%20clear%20instructions%2C%20with%20a%20video%2C%20a%20downloadable%20sample%20workbook%20and%20links%20to%20more%20advanced%20examples.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1882367%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1882367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bthank%20you%2C%20this%20was%20very%20straightforward%20and%20much%20easier%20than%20what%20I%20was%20trying%20on%20my%20own!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted

@KJSherman 

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

Highlighted

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