★ Want to automate Excel? Check out our training academy ★ ★ Get the example file ★ Sign up for our free Insiders program and get the example file: File Reference for this video: 0234 Dependent drop-down ★ About this video ★ In this video, we are looking at the easiest method for creating dependent drop-down lists in Excel. It's a simple method using range functions. So, let's get started. 0:00 Introduction 0:16 Scenario 0:57 Creating dynamic ranges 2:25 Drop down list 2:59 Range functions 3:25 Dependent drop-down lists 6:14 Multi-level dependent drop-down lists 8:08 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ ★ Where to find Excel Off The Grid ★ Blog: Twitter: #MsExcel