Published On Oct 2, 2024
Learn how to use VLOOKUP in Excel to quickly and efficiently find values in large datasets. In this video, we cover how to master VLOOKUP in Microsoft Excel, from understanding the basics of vertical lookup to avoiding common mistakes. Whether you're new to Excel or looking to improve your skills, this VLOOKUP tutorial will guide you through all the key steps.
Host: Kevin Stratvert
📚 RESOURCES
Download the practice workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whexx4...
⌚ TIMESTAMPS
0:00 - Introduction to VLOOKUP in Excel
0:37 - Start the VLOOKUP function
0:51 - Lookup value explained
1:15 - Define the table array
1:37 - Column index number overview
2:01 - Approximate vs. exact match
2:30 - Use the Insert Function helper (FX icon)
3:04 - Understand relative references and the #N/A error
3:52 - Fix the table reference with absolute references (F4 key)
4:29 - Convert the data range into an Excel table
5:25 - Wrap up
📺 RELATED VIDEOS
Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
Official website: http://www.kevinstratvert.com
LinkedIn: / kevinstratvert
Discord: https://bit.ly/KevinStratvertDiscord
Twitter: / kevstrat
Facebook: / kevin-stratvert-101912218227818
TikTok: / kevinstratvert
Instagram: / kevinstratvert
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 📺 Descript AI Video Editor | https://get.descript.com/sf22jb63w2tx
✅ 💵 QuickBooks Online: https://bit.ly/intuitquickbooksonline
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut Video Editor | https://bit.ly/installcapcut
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?...
🙌 SUPPORT THE CHANNEL
Hit the THANKS button in any video!
Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #vlookup #vlookupinexcel