Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List
- Published on Nov 1, 2017
- Download the Workbook here: www.xelplus.com/excel-dependent-drop-down-lists-multiple-words-spaces/
This video builds on the methods shown in a previous video: thexvid.com/video/CIJbcBBH88M/video.html 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: thexvid.com/video/avVLznHODVA/video.html
Index Match basics explained: thexvid.com/video/F264FpBDX28/video.html
★ My Online Excel Courses ► courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
EXCEL RESOURCES I Recommend: www.xelplus.com/resources/
Get Office 365: microsoft.msafflnk.net/15OEg
Microsoft Surface: microsoft.msafflnk.net/c/1327040/451518/7593
Screen recorder: techsmith.pxf.io/c/1252781/347799/5161
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!