Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com

In this stepbystep tutorial, first we learn how to create a basic dropdown list in Microsoft Excel. Next, we look at how to create multiple dependent dropdown lists. With multiple dependent dropdown lists, the second or the subsequent dropdown list adjusts based on the selection in the first drop down list. This is helpful to validate data entry.

Few quick notes:
✅ This requires the =xlookup function, which is available as part of Microsoft 365. Unfortunately, older versions of Excel don't currently support this.
✅ To use this on multiple rows, use =transpose as part of the formula: =TRANSPOSE(SORT(UNIQUE(XLOOKUP(A8,Table1[#Headers],Table1),,TRUE))) Then you'll just need to copy the formula down for however many rows you have. You can even place the filtered list on a separate sheet or just hide those columns.
✅ You can access the sample sheet here: https://1drv.ms/x/s!AmxrofZZlZwhMc5Q...

Additional resources
Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZwhMc5Q...
How to Create a simple Excel Drop Down list:    • Excel Drop Down List Tutorial  
Indepth tutorial on Excel look up functions:    • VLOOKUP in Excel | Tutorial for Begin...  
Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com'>https://kevinstratvert.thinkific.com

⌚ Timestamps
0:00 Introduction
0:42 Create simple dropdown list
2:50 Create dependent dropdown list
3:43 Use XLOOKUP function
6:17 Create dropdown list with XLOOKUP output
7:07 Use UNIQUE function
9:20 Use SORT function
10:44 Wrap up

Watch related playlists
Playlist with all my videos on Excel:    • ❎ How to use Excel  

Connect with me on social
LinkedIn:   / kevinstratvert  
Twitter:   / kevstrat  
Facebook:   / kevinstratvert101912218227818  
TikTok:   / kevinstratvert  

Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?...

Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com

Support me with your Amazon purchases: https://amzn.to/3kCP2yz

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same.

#stratvert