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

In this step-by-step tutorial, first we learn how to create a basic dropdown list in Microsoft Excel. Next, we look at how to create multiple dependent drop-down lists. With multiple dependent drop-down lists, the second or the subsequent drop-down 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!AmxrofZZlZ-whMc5Q7m_2f01bKrmyw?e=4vfT8e

Additional resources
– Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whMc5Q7m_2f01bKrmyw?e=Rp4bc2
– How to Create a simple Excel Drop Down list: https://youtu.be/QR04owFaJy4
– In-depth tutorial on Excel look up functions: https://youtu.be/DZEPA9UhLBw
– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

Timestamps
0:00 Introduction
0:42 Create simple drop-down list
2:50 Create dependent drop-down list
3:43 Use XLOOKUP function
6:17 Create drop-down 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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

Connect with me on social
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert

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

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.