Premium Only Content

Excel Dependent Drop Down List with Tabular Data without Named Ranges
Nov 9, 2017 Excel Dashboards & Reports
Download the Workbook: http://www.xelplus.com/excel-dependent-drop-down-list-tabular-data/
Find out how to create a dependent drop down list in Excel based on a Tabular data set. Instead of having the contents of each drop-down beside each other as we had in the previous tutorial, we now have the contents of each drop-down right below one another. To distinguish which category belongs to which parent, the parent is listed right beside the category. This provides us with a table that has two columns. One for the parent and the other for the content.
We would like to come up with a dynamic formula so that when the user selects a category from the first drop-down (i.e. the parent list), Excel figures out which part of the tabular data-set to include in the 2nd drop-down. This means we need a dynamic formula that always shows the part of the table that has a match for the parent category.
Link to extracting unique items for drop-down: https://youtu.be/7fYlWeMQ6L8
Link to OFFSET video: https://youtu.be/RPTQjbk2qy4
Link to the other Dependent Drop-down List video: https://youtu.be/w7cHgsFirLk
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
LIVE
LFA TV
12 hours agoALL DAY LIVE STREAM - 4/25/25
13,228 watching -
25:12
JasminLaine
18 hours agoMark Carney Gets GRILLED By Reporter—Lies Finally Get Fact-Checked… PUBLICLY
18K33 -
11:46
Tactical Considerations
15 hours ago $4.80 earnedKimber CDS9 The Micro 1911 That Seems To Have It All
25.7K4 -
15:48
IsaacButterfield
1 day ago $3.45 earnedWoke Lunatic ATTACKS My 2 Year Old Son!!
31.2K28 -
55:00
The Hannah Faulkner Show
22 hours ago $2.55 earnedKLAUS SCHWAB RESIGNS & A NEW POPE with Mike Crispi | The Hannah Faulkner Show
30.1K8 -
36:50
Uncommon Sense In Current Times
14 hours ago $1.28 earnedHomicide Detective Finds God While Investigating True Crime | J. Warner Wallace
31.7K14 -
1:00:51
Trumpet Daily
22 hours ago $4.53 earnedAmerica’s Shameful Foreign Policy - Trumpet Daily | Apr. 24, 2025
30.2K13 -
17:18
VSOGunChannel
17 hours ago $1.01 earnedDNT HYDRA- A Thermal Sight You Can Actually Afford
26.6K5 -
10:10
Mrgunsngear
15 hours ago $8.32 earnedNew Trijicon MRO SD - The Best American Made Red Dot Optic?
67.6K11 -
13:42
SantaSurfing
18 hours ago4/24/2025 - Part 1 on Endless Frontiers Efficient & Powerful Tesla Homes! Revolutionary!
81.9K58