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: https://www.youtube.com/watch?v=4c0CLUER6nw
Or the good old king of lookups, INDEX MATCH: https://www.youtube.com/watch?v=6JhbY8Mku1A

FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: https://spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: https://spreadsheeto.com/free-power-bi-training/

PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: https://spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: https://spreadsheeto.com/vba-masterclass/
Power BI Essentials. Master Power BI in 12 hours: https://spreadsheeto.com/power-bi/

‍HIRE ME AND MY TEAM
We develop custom Excel systems: https://spreadsheeto.com/excel-consultant/

#exceltips #exceltutorial #microsoft365 #officeproductivity

Please take the opportunity to connect and share this video with your friends and family if you find it useful.