Excel Data Validation Dependent Lists with INDIRECT and named range in Excel spreadsheet
Excel Is Simple
data validationdata validation drop down listdata validation in exceldata validation in excel 2007exceldata validation in excel 2010data validation in excel 2013data validation in excel 2016data validation listdependent data validationdependent data validationsexcel basicsexcel for beginnersexcel formulasexcel tutorialexcel tutorial for beginnershow to add dependent data validation in excelhow to add dependent data validations in exceleducation
A common question from Excel users is along the lines of; I have a list in a cell that has used Data-Validation with the "List" option. I would like to have another cell display a list that is depended on the item chosen in my first list.
There are quite a few ways to achieve this, but the easiest by far is using the INDIRECT functions in the validation. The INDIRECT Function return the reference returned by a text string.
Here is your guide on how to add dependent data validations in excel You will find a refresher course to data validations and two possible ways to add dependent data validations in excel.
------------------------
2019-07-10
0.71025757 LBC
Copyrighted (contact publisher)
64651826 Bytes