Premium Only Content

Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List
Nov 1, 2017 Excel Dashboards & Reports
Download the Workbook here: http://www.xelplus.com/excel-dependent-drop-down-lists-multiple-words-spaces/
This video builds on the methods shown in a previous video: https://youtu.be/CIJbcBBH88M which showed how to create an Excel dynamic drop-down data validation list that was dependent on the selection of another drop-down.
In that video the first list contained numbers whereas in this video we take a look at a more realistic case where the first list contains text with multiple words and spaces. This approach works if your drop downs are in different worksheets as well.
Check out this video to create drop-down lists on tabular data sets: https://youtu.be/avVLznHODVA
Index Match basics explained: https://youtu.be/F264FpBDX28
★ 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
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
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
-
11:03
Actual Justice Warrior
20 hours agoINSANE McDonald's Employee Stabs Manager Over NOTHING
5.11K15 -
12:20
Nikko Ortiz
15 hours agoWorst TikTok Crashouts Part 4
8.87K7 -
34:00
The Crypto Report
17 hours agoALTCOIN SEASON BEGINS? (Ethereum Outperforming Bitcoin!) LIVE Crypto News!!!
5.52K1 -
2:02:19
Melonie Mac
11 hours agoGo Boom Live Ep 55!
11.3K6 -
1:57:15
Side Scrollers Podcast
19 hours agoZelda Actress NOT a Dude, Darth Vader’s Lightsaber Auction, Evil Elmo Update | Side Scrollers LIVE
82.9K3 -
1:49:58
Omar Elattar
5 days agoLUKE BELMAR: From Broke To $50 Million | Crypto Predictions | Truth About God, Bible & The Matrix
15.5K -
10:17
Dr Disrespect
1 day agoIt's Time To Get Serious
128K17 -
1:56:18
The Michelle Moore Show
19 hours ago'Parasites and Worms...What You Need To Know' Guest, Kim Rogers 'The Worm Queen' The Michelle Moore Show (July 16, 2025)
27.4K16 -
33:32
Solar Groove Muzic
1 day ago $1.49 earnedSUMMER AFRO HOUSE | Amalfi Coast 2025 (Adam Port, Avicii, The Weeknd, Black Coffee, Diplo)
20K -
39:22
The Brett Cooper Show
2 days ago $5.41 earnedBieber’s Big F-You To Hollywood & Trump Gets Ratio’d Over Epstein | Episode 48
19.7K14