Auto-Populate Cells From Drop-Down Selection in Excel (3 steps)
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 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?
aaaaand .....for for horizontal dont worry there is the HLOOKUP function