How to Create Dynamic Dropdown list with a Table in Excel

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

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

[felipescherer]

Fast and easy to understand explanation. Thanks for sharing!

[sadastgheibi]

Hi, its best method for data validation list. Easy, Fast and complete. very good

[rashidelbahra]

Simple and efficient. I appreciate your video, thanks!

[Yorumcu]

Great video(Update this feature to program)

[lawrencetan]

You have made my day my friend, a simple and working solution

[richardg.]

Thank you. This worked perfectly for me.

[Yorumcu]

Best video about Data Validations Thank you .my friend sure you have a subscriber with this great short video
I want ask that too
if I addd this .Is this commands can work ith big records too (I will use in average 5000(five thousand ) record (only one coulon and average 25 character in every cell) .is this make very slowly to excel? (I used the convert to table method but it was very slow (no INDIRECT command)
Thank you

[syedaliraza]

Awesome video. Is this MS office 365 pro plus version on which you are performing.

[andychavez]

Good tutorial, Will this be possible if the list came from one of the columns in a named table?

[z--zoon]

Sorry to inform you but this is not a Dynamic dropdown list. Its just a list of rows.

[ansharullahahmad]

how about list from another worksheet?

[rajavigneshrrv]

Hi I have few more doubts in Excel. Is there any way to contact you ?