How to Create Multiple Dependent Drop-Down Lists in Excel – Automatically Update with New Values

In this video, I’ll show you how to create multiple dependent drop-down lists in Excel. Create two lists that contain Income and Expenses. After that, we will convert the two ranges into Excel Tables. To do that, select the first range. Click the Insert Tab, then click the Table icon. Make sure the /”My table has headers checkbox/” option is checked. Then click OK. Use the same method to create the second table.

We need to add names to the tables. Click the name box. Add a name to the first table. Then, add a name to the second table. Now, we will use the INDIRECT function to return a reference specified by a text string.
Add cell G2 as an argument. If you change the value, the list will be changed dynamically. Try to add a new item; the list will be refreshed.

Okay, jump back to the main Worksheet. Select the category range.
We use Data validation to create a drop-down list. Select the Data Tab.
Click Data validation. Select the List option. Then, add Income and Expenses as a source range. Click OK. Okay, let us see how the drop-down list works. Select Income from the list. Now select the second range and apply Data validation. Select the List option. Then, use the INDIRECT formula. Click OK to close the dialog box. We have Income in the first column. Use the second drop-down list. As you see, the list depends on the selected item in the first column. Using this method, you can add multiple categories quickly. So, creating a dependent drop-down list is not rocket science.

Chapters:

00:00 Intro
00:09 How to Create Multiple Dependent Drop-Down Lists in Excel
00:13 Create Excel Tables
00:44 Add Names
00:58 Use the INDIRECT function
01:17 Apply data validation

LEARN MORE in my Excel tutorials: https://excelkid.com/

SUBSCRIBE if you’d like more tips and tutorials like this.

SHARE this video and spread the Excel love.

Or if you are in a hurry, please click the

#excel #exceltips #exceltutorial

Please take the opportunity to connect and share this video with your friends and family if you find it useful.