Forum Discussion
Data Validation List based on another List
I'm not sure how this would work, but here's what I'm looking at.
I'm using Excel to track my outputs of certain materials, bought in different locations, however not every location offers every item. E.g. Factory 1 offers Materials 1-5, Factory 2 offers Materials 1-7 and Factory 3 only offers Materials 6-7.
I want to create a Data Validation List for the Factory selection, which is fairly standard, but then, in the next column, have another List to select from the list of materials that they supply.
Can anyone help?
1 Reply
Please google for "excel dependent drop down list", lot of tutorials. First what appeared Easy Steps Excel Dependent Drop Down List Data Validation (contextures.com)
