Рет қаралды 12,641
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: • How to Use the NEW & I...
Or the good old king of lookups, INDEX MATCH: • INDEX MATCH Excel Tuto...
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: spreadsheeto.com/free-power-b...
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: spreadsheeto.com/power-bi/
🧑💻HIRE ME AND MY TEAM
We develop custom Excel systems: spreadsheeto.com/excel-consul...
#exceltips #exceltutorial #microsoft365 #officeproductivity