🔥 Learn Excel in just 2 hours: [ Ссылка ]
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: [ Ссылка ]
👋 Additional resources
- Sample file to follow along: [ Ссылка ]
- How to Create a simple Excel Drop Down list: [ Ссылка ]
- In-depth tutorial on Excel look up functions: [ Ссылка ]
- Learn the fundamentals of Excel in just 2 hours: [ Ссылка ]
⌚ 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: [ Ссылка ]
🚩 Connect with me on social
- LinkedIn: [ Ссылка ]
- Twitter: [ Ссылка ]
- Facebook: [ Ссылка ]
- TikTok: [ Ссылка ]
🔔 Subscribe to my YouTube channel
[ Ссылка ]
🎬 Want to watch again? Navigate back to my YouTube channel quickly
[ Ссылка ]
🛍 Support me with your Amazon purchases: [ Ссылка ]
⚖ 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
Dependent Drop Down List in Excel Tutorial
Теги
kevin stratvertmultipledependentmultiple dependent drop down listsdrop downdrop down listdrop down listsdrop-downexcelmicrosoft excelmicrosoftexcel drop down listlistdropdowndrop down list in exceltutorialexcel drop down list tutorialhow tohow to create drop down list in excelkevinstratvertdropdowndropdown in excelcreate drop downhow to addcreate a drop downexcel tutorialdatadata validationcreatingmenucreateaddin excellists