Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Dependent Drop Down List in Excel Tutorial. That video is uploaded by Kevin Stratvert at 2021-07-06T00:00:12-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [vh2jdOQ5VLs]
| Name | Dependent Drop Down List in Excel Tutorial |
| Video Uploader | Video From Kevin Stratvert |
| Upload Date | This Video Uploaded At 06-07-2021 07:00:12 |
| Video Discription | ๐ฅ 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 vh2jdOQ5VLs |
| Category | Science & Technology |
| Tags | kevin stratvert | multiple | dependent | multiple dependent drop down lists | drop down | drop down list | drop down lists | drop-down | excel | microsoft excel | microsoft | excel drop down list | list | drop | down | drop down list in excel | tutorial | excel drop down list tutorial | how to | how to create drop down list in excel | kevin | stratvert | dropdown | dropdown in excel | create drop down | how to add | create a drop down | excel tutorial | data | data validation | creating | menu | create | add | in excel | lists |
