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:
- Learn the fundamentals of Excel in just 2 hours:
⌚ 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:
NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week:
CONNECT WITH ME
- Official website:
- LinkedIn:
- Discord:
- Twitter:
- Facebook:
- TikTok:
- Instagram:
TOOLS AND DISCOUNTS
️ Voicemod AI Voice Changer | 5% off |
Squarespace Websites |
Grammarly |
️ Shopify |
Notion |
️ Figma |
ElevenLabs Text-to-Speech |
MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours:
REQUEST VIDEOS
SUBSCRIBE ON YOUTUBE
SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link:
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.
Смотрите видео VLOOKUP in Excel | Tutorial for Beginners онлайн без регистрации, длительностью 32 минут 09 секунд в хорошем hd качестве. Это видео добавил пользователь Kevin Stratvert 10 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2 миллионов раз и оно понравилось 30 тысяч людям.