Excel DYNAMIC Drop-downs in an Order Form. Cool Data Validation technique!
💻 Check out my NEW online course Excel Express https://claritix.co.uk/excel-express
🤝 Connect/Follow me on LinkedIn: http://bit.ly/MyLinkedIn_Dan
💡 BLUE: Advanced-level
► This video is Part 2/2 in a series on Data Validation. If you watched Part 1 you'll have seen all things Data Validation - how to create List, restrict Max/Min values, Whole Numbers vs Decimals, Dates...and even how to customise amusing, or not so amusing, Error Alert messages for when you're colleagues make a mistake 🙄
► This video shows how we can create DYNAMIC Drop-down Lists, meaning the choices you have in the Drop-down List depend on the choice you picked in another Drop-down List! It's cool so check it out! 😃
► The context of the video is creating an Order Form for a spa business where first a Category of products is selected in Drop-down List 1, and then a Product from that Category is selected in Drop-down List 2. We utilise the CHOOSE function to create this, and then INDEX & MATCH to look up prices. Enjoy! 🎈
💥 Related Videos 💥
★ MATCH - the cornerstone of lookups: • Video
★ CHOOSE - When to use CHOOSE vs INDEX: • Video
★ INDEX & MATCH Part 1 - Ultimate lookup solution: • Video
★ Data Validation Part 1 - Drop-downs & more: • Excel Data Validation - Drop-down lists & ...