Excel

Dependent Drop Down Lists in Excel

by Leila Gharani

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.

Published on: March 23, 2017

Last modified: May 28, 2024

Category: Dashboards, Charts & Features,Excel,Formulas

Tagged as: CHOOSE function, Dependent Dropdown, Drop-down, Dropdown List, INDEX function, INDIRECT, OFFSET

Leila Gharani

Founder of XelPlus and ten-time Microsoft MVP. Leila helps over 500,000 professionals master Excel, Power BI, and data automation through practical, real-world training.

More About Leila Join 500,000+ professionals in our courses

Join the Course

Python in Excel For the Real World

A hands-on course for Excel users: use Python to forecast, apply machine learning, and build charts Excel can’t make. No coding background needed.

Learn More

Featured Course

Business Charts in Excel

Create professional Excel charts that tell a story AND update automatically. Learn the formulas and design techniques that get your reports noticed.

Learn More

First step to Excel

Excel Essentials for the Real World

A hands-on Excel course for professionals who never had formal training. Fill in what got skipped, so you stop doing things the long way without knowing there was a shorter one.

Learn More

This course helped me catch up and put it all together

Featured Course

Visually Effective Excel Dashboards

Learn to design impressive Excel Dashboards. Use smart functions for clear, interactive dashboards. Make them so easy to use that everyone will love them!

Learn More

Featured Course

Master Excel Power Query – Beginner to Pro

Power Query is the most underused tool in Excel. Build the monthly cleanup once, then just refresh. One member took a monthly report from 7 days down to 2 hours.

Learn More

Featured Tutorials

Excel

10 Excel Pivot Table Tips and Tricks (2026 Pro Guide)

Power Excel

You WON’T BELIEVE These 10 HIDDEN Features in Excel Power Query

Excel

How To Use Excel FILTER Function With Multiple Criteria

Power BI

What is Power BI – And What is It Used For?

Excel

Excel Settings You Should Change Now

Excel

How to Combine Multiple Sheets in Excel with VSTACK

Accounting & Finance

How to Learn Financial Analysis

Get it all

Black Belt Excel Bundle

This Excel Black Belt Package includes EIGHT of our Popular Courses. You’ll learn high-value, in-depth Excel skills that solve real problems.

Learn More

My Excel knowledge is improved a lot after the courses. My work is much faster and easier prepared and the presentations are much more appreciated.

Join Between the Sheets

Kickstart your week with our free newsletter covering Excel hacks, Power BI tips, and the latest in AI. You get to stay updated and get all the insights you need, delivered straight to your inbox.

Subscribe Now

You can unsubscribe anytime of course.