How to automatically populate cells based on what's in another cell. This concept is used for all kinds of templates or fillable forms. In this example, I show you how to use VLOOKUP to populate customer data fields based on the customer name selected with a drop-down. With this, we're creating a semi-automatic order confirmation form🏆 🕒 TIMESTAMPS 0:00 Auto-populate data based on drop-down selection 0:44 Insert drop-down list 1:25 Write lookup functions (e.g. VLOOKUP) 5:30 Remove errors to ensure it's easy to understand 👍 LIKE AND SUBSCRIBE If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment! 🍿 RECOMMENDED VIDEOS The new (and awesome) XLOOKUP function: Or the good old king of lookups, INDEX MATCH: 🎁FREE COURSES Try my free 30-minute Excel course and join 100,000+ students: Learn Power BI for free and create impactful reports in just 30 minutes: 🏆PAID COURSES Zero to Hero. From beginner to Excel expert in 14 hours: VBA Masterclass. Become a VBA pro in 20 hours: Power BI Essentials. Master Power BI in 12 hours: 🧑‍💻HIRE ME AND MY TEAM We develop custom Excel systems: #exceltips #exceltutorial #microsoft365 #officeproductivity