How to Use VLOOKUP in Excel - 5 Simple Steps (+Formula Example)
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- The VLOOKUP function looks for a specific value and returns a value from a corresponding column in the same row as where it finds the value. In other words, it helps you join and match data from multiple sheets or Excel files🔎
🕒 TIMESTAMPS
0:00 What VLOOKUP does and how it works
1:30 Step 1: Function name and syntax
1:57 Step 2: The lookup value
2:18 Step 3: The table array
3:55 Step 4: Column index number
5:10 Step 5: Range lookup / match type (exact or approximate match)
6:24 Additional comment on the table array
👍 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
XLOOKUP: • How to Use the NEW & I...
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/
Thnx, could you share with us if we have a duplicated valu as its only return the first match