Excel Dependent Drop Downs with FILTER
Download File: https://www.excel-university.com/yt_w...
Learn Excel Fast:
https://www.excel-university.com/yt
https://www.excel-university.com/blog
This video shows how to create multiple dependent drop downs using the FILTER function. These are also known as cascading or conditional drop downs, where the choices in a drop down depend on the selection made in a previous drop down. The technique presented enables you to create as many drop downs as you need, and there is no VBA coding needed.
Note: depending on your version of Excel, you may not have access to the FILTER function. If not, check out this post which uses legacy functions or this post which uses slicers.
