VLOOKUP in Excel | Tutorial for Beginners

๐Ÿ”ฅ Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com

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: https://1drv.ms/x/s!AmxrofZZlZ-whK4bPgcKpfbw0Iub5A?e=1NQpEF
– Learn the fundamentals of Excel in just 2 hours: https://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: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

๐Ÿ“ฉ 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: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://bit.ly/KevinStratvertDiscord
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/

๐ŸŽ TOOLS AND DISCOUNTS
โœ… ๐ŸŽ™๏ธ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
โœ… ๐ŸŒ Squarespace Websites | https://squarespace.syuh.net/XYaqYM
โœ… ๐Ÿ” Grammarly | https://grammarly.go2cloud.org/SH3nL
โœ… ๐Ÿ›๏ธ Shopify | https://shopify.pxf.io/XY9rPa
โœ… ๐Ÿ“‹ Notion | https://affiliate.notion.so/rffva4tr71ax
โœ… ๐Ÿ–ผ๏ธ Figma | https://psxid.figma.com/lqjg97licpry
โœ… ๐Ÿค– 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?sub_confirmation=1

๐Ÿ™Œ 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 #excel

Related Posts

Language ยป
close
Thanks !

Thanks for sharing this, you are awesome !