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
-
1:38:36
Glenn Greenwald
5 hours agoProf. John Mearsheimer on Israel's Destruction of Gaza, Trump Admin Attacks on Universities & Speech, Yemen Bombings, Tariffs & Competition with China; Plus: Q&A with Glenn | SYSTEM UPDATE #434
100K51 -
LIVE
SpartakusLIVE
1 day agoThe MACHINE is back after a RESTFUL 4 hours of sleep
327 watching -
LIVE
I_Came_With_Fire_Podcast
10 hours agoTARIFF TAKEOVER | REDCOATS 2.0 | DOGE FINDS SOMETHING HORRIBLE
203 watching -
LIVE
Eternal_Spartan
2 hours agoLive at 9pm Central! Come Hang Out w/ a USMC Vet Playing HALO! Can't Wait to See Everyone!!
129 watching -
LIVE
Welsh Girl
4 hours ago🔴 Minecraft Basics Explained – DAY 1
16 watching -
LIVE
SynthTrax & DJ Cheezus Livestreams
1 day agoFriday Night Synthwave 80s 90s Electronica and more DJ MIX Livestream Trip-Hop SPECIAL EDITION
636 watching -
4:03:27
FusedAegisTV
8 hours agoRumble Smackdown! #001 Street Fighter 6 $500 Online Tournament
38.6K5 -
55:58
BonginoReport
5 hours agoCan Trump Make TikTok Great Again? (Ep. 20) - Nightly Scroll with Hayley Caronia - 04/04/25
118K71 -
LIVE
Jorba4
1 hour ago🔴Live-Jorba4- COD WARZONE- VERDANSK FRIDAY. Hot drops W/ XxXAztecWarrior and Lumpy Potato X2
145 watching -
4:33:11
Nerdrotic
7 hours ago $27.13 earnedPost-Apocalyptic Woke Hollywood, MineCRAP, CinemaCONNED - Friday Night Tights 348, Chris Gore & Rags
106K14