Learn how to create conditional drop-down Excel Validation lists using the INDEX function, OFFSET, CHOOSE and INDIRECT Functions.
In this video, I’ll show you how you can use the OFFSET formula, CHOOSE formula and INDIRECT function to create drop-down lists that are dependent on another drop down list.
One aim, many ways to get there. Which one do you like?
To see how to create a dependent drop down list in Excel, when your first list can contain many words and spaces, check out this tutorial.
Watch the steps in this video:
Feel free to Download the Workbook HERE.