Dependent dropdown list in Excel

Hello friends! Today we’ll be learning create dependent drop down list in Excel. Excel sheet used in this tutorial is attached to this blogpost to download.

1. Create a pivot table from the data and create a pivot table to get the unique list of columns
2. Create a data validation using the formula while comparing the first value for example:

=INDIRECT("Reference!$B"&MATCH(A11,Reference!A:A,0)&":$B"&MAX(IF(Reference!A:A=A11,ROW(Reference!A:A))))

3. Since this array formula hit CTRL + Enter to apply the formula

Download the file here
Keep visiting Analytics Tuts for more tutorials.

Thanks for reading! Comment your suggestions and queries