Create Dynamic Drop Down List

This post will guide you how to create a dynamic drop down list in Excel. How do I quickly create a dynamic drop down list in Excel.

Create Dynamic Drop Down List


Assuming that you want to create two drop down list in your current worksheet, and when choose a value in one drop down list, and the values in another drop down list will be updated automatically. How to achieve it. Let’s see the below detailed steps.

#1 select the range of cells A1:B1, go to FORMULAS tab, click Define Name command under Defined Names group. The New Name dialog will open.

create dynamic drop down list1

#2 type one Name in the Name text box. Then click OK button.

#3 select the range of cells A1:A4 to create another defined name.

create dynamic drop down list3

#4 select the range of cells B1:B4 to create one more defined name.

create dynamic drop down list4

#5 create the first drop down list, go to DATA tab, Click Data Validation command under Data Tools group. And select Data Validation item from the pop up menu list. The Data Validation dialog will open.

create dynamic drop down list5

#6 click Settings tab, select List from the Allow drop down list box. And type the formula =Names in the source text box. Click Ok button.

create dynamic drop down list6

#7 the first drop-down list has been created in Cell C1.

create dynamic drop down list7

#8 click Cell D1 to select this cell, go to DATA tab, Click Data Validation command under Data Tools group to create the second drop down list. Click Settings tab, select List from the Allow drop down list box. And type the formula =indirect(C1) in the source text box. Click Ok button.

create dynamic drop down list8

#9 choose one value from the first drop down list, and you will see that the values in the second drop down list will be updated.

create dynamic drop down list9

Related Posts

How to Use 3D SUM Multiple Worksheets
3D sum multiple worksheets1

To sum a range of numbers is straightforward for most Excel users, but do you know how to establish a 3D reference to total the same range of numerous sheets. In this post, I will present the steps for this ...

Extract all the matches with helper Column
how to extract all matches with helper column1

With Excel's powerful functions IF, INDEX, and MATCH, we can find exactly what you're looking for with a few clicks of the mouse. This step-by-step tutorial will show how easy it is to extract data using these tools and more! ...

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value
If Value is Greater Than A Certain Value 1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank
If Cell is Not Blank 6

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

VBA Macro For VLOOKUP From Another Sheet
vba macro for vlookup from another sheet1

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

If Cell is Blank
If Cell is Blank_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String
If cell equals certain text_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2
If cell contains text1 or text2_1

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

Sidebar