Create MULTIPLE DEPENDENT DROP-DOWN in Excel? (with/without XLOOKUP)
In this tutorial, we’ll walk you through creating a dynamic multi-level drop-down list in Excel. Learn how to link categories, sub-categories, and products using both XLOOKUP (available in Excel 2021 and Excel 365) and an alternative method for earlier versions of Excel. We’ll also cover how to make these lists dynamic so they automatically update when new data is added. Plus, discover a bonus trick using conditional formatting to highlight errors and ensure you select the correct options.
What You’ll Learn:
Creating multi-level drop-down lists in Excel using XLOOKUP for dynamic lists
An alternative method without XLOOKUP
Using conditional formatting to prevent errors
Timestamps:
0:00 Introduction
0:43 Method 1: Drop-down using XLOOKUP
3:44 Method 2: Drop-down without XLOOKUP
7:00 Bonus Trick
8:24 End
Checkout my other videos:
5 Advanced DATA VALIDATION TRICKS in Excel (with Examples)
• 5 Advanced DATA VALIDATION TRICKS in ...
Top 10 Microsoft EXCEL Tricks in 2024 YOU MUST KNOW!!!
• Top 10 Microsoft EXCEL Tricks in 2024...
🔔 Don't forget to LIKE, COMMENT, and SUBSCRIBE for more quick Excel tips and tutorials!
Also Follow me on
Tiktok: / the_excel_experience
Instagram: / the_excel_experience
Threads: https://www.threads.net/@the_excel_ex...
Support the Channel:
If you found this video helpful, please give it a thumbs up and consider subscribing for more Excel tips and tricks. Don't forget to hit the notification bell so you never miss an update!
Have Questions or Feedback?
Leave a comment below! I love hearing from you and am here to help.
#excelshorts #exceltips #exceltutorial #excelfunction #excelnewfunction #dropdownlist #dropdown #datavalidation #spreadsheettricks #datavalidation #xlookup #exceltricks