HDTutorial
EN
How to Create Dynamic Drop-down list with Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create Dynamic Drop-down list with Excel

45,621 views November 10, 2019 3:10

Watch on YouTube
Channelexcelexercice

Chapters

Description from the creator

How to create dynamic dropdown list ? Let's say you add new data to your source, and your dropdown list is updated automatically.

Magic? No, just a Table and the INDIRECT function and the job is done? So you can use this solution with with all the Excel version since Excel 2007

You can try to do this example online excel-exercise.com/project/how-to-create-a-drop…

00:00 Introduction
00:23 Create a standard dropdown list
00:59 Add your data in a Table
01:27 Linking Table
02:16 Use the INDIRECT function

About this tutorial

excelexercice published this 3:10 video tutorial on November 10, 2019. It has been watched 45,621 times on YouTube.

Category
Education
Duration
3:10
Published
November 10, 2019
Views
45,621
Likes
316

Tags

Share

This tutorial in other languages