Auto-Populate Cells From Drop-Down Selection in Excel (3 steps)
HTML-код
- Опубликовано: 22 июл 2024
- 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
👋 3 ways I can help you!
1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com
2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/
3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/
This is amazing, thank you!
This is so handy for what i wanna do!!! Thanks!
Amazing thank you
Hi, this video is great, and I am doing something similar however my "customer name" which is "cables" to me has multiple tables for different types, then based on each table there is different sizes. Is there a way to select a certain table, then from there list only the sizes in that table and select which one?
Say I want to have that formula carry down a table, what would I add into it? So instead of having just a single Customer Name cell I have Customer Name as a header and Customer Address as a header and every time I select Customer Name it will auto populate the Customer Address. Thank you!
How do you do this when the cells are merged?