Easily Create Multiple dependend dropdown lists in Excel.
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/gunxkv01mh
In this video you'll learn how to create multiple dependent dropdown lists in Excel. This will include an XLOOKUP and data validation. Once this is clear, we'll also use the autopopulate feature that will change depending on your dropdown answers. We'll do this by combining the TRANSPOSE funcion with the XLOOKUP. FInally, we'll create an error check so the dropdown choices make sense. For example, if you select Europe as the region, it should only allow you to select European countries. For this we'll use the COUNTIFS and the XLOOKUP to make an error check, alongside a conditinal formatting to make it stand out.
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🚀 All our courses: https://www.careerprinciples.com/all-courses
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Single Dependent Dropdown
3:38 - Multiple Dependent Dropdowns
5:50 - Autopopulate Dropdown Results
7:51 - Bonus: Error Check for Dropdown Choice
