VLOOKUP in Excel | Tutorial for Beginners

In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

👋 Additional resources:
Sample file to follow along: 1drv.ms/x/s!AmxrofZZlZ-whK4bPgcKpfbw0Iub5A?e=1NQpE…
Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com/

⌚ Timestamps
0:00 Introduction
1:47 Organize data properly for VLOOKUP
5:38 VLOOKUP Exact match
9:34 Improve error message with IFERROR
11:10 VLOOKUP Closest match
14:48 VLOOKUP Across sheets
15:43 HLOOKUP
18:21 XLOOKUP Simple example
22:53 XLOOKUP Combined with other functions
24:54 XLOOKUP Returns an array
26:42 XLOOKUP Match modes
28:30 XLOOKUP Search modes
31:24 Wrap up

📃 Watch related playlists and 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: kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
Official website: www.kevinstratvert.com/
LinkedIn: www.linkedin.com/in/kevinstratvert/
Discord: bit.ly/KevinStratvertDiscord
Twitter: twitter.com/kevstrat
Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
TikTok: www.tiktok.com/@kevinstratvert
Instagram: www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
Hit the THANKS button in any video!
Amazon affiliate link: 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 #excel