Create Multi Level Dependent Dropdown list in excel using [INDIRECT]
Автор: Advait Analytics
Загружено: 2026-02-05
Просмотров: 119
Описание:
In this video, you’ll learn how to build a 3-level dependent drop-down list in Excel using INDIRECT function and Named Ranges — a method that works in all Excel versions.
We’ll go beyond “how to click” and focus on why and how this system works.
You’ll also learn:
What the INDIRECT function actually does
How Excel converts text into references
Why Named Ranges are critical for dependent drop-downs
How to debug broken drop-downs using Name Manager
Important note
There is a newer and easier method using functions like XLOOKUP, FILTER, and UNIQUE,
but those only work in Excel 2021 and Excel 365.
I’ve covered that modern approach in a separate video —
This video focuses on the INDIRECT method, so you understand the core mechanics — not just copy steps
If you find this helpful:
👍 Like the video
💬 Comment if you want the template or future automation projects
🔔 Subscribe for more Excel workflows
Повторяем попытку...
![Create Multi Level Dependent Dropdown list in excel using [INDIRECT]](https://imager.clipsaver.ru/oHfdNT3CWb4/max.jpg)
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Create Multi Level Dependent Dropdown list in excel using [XLOOKUP]](https://imager.clipsaver.ru/M6ejelkOXVs/max.jpg)
