How to use VLOOKUP in Excel – Complete Tutorial

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:!AmxrofZZlZ-whK4bPgcKpfbw0Iub5A?e=1NQpEF

⌚ 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
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:

🚩 Connect with me on social:
– LinkedIn:
– Twitter:
– Facebook:

πŸ”” Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

πŸ› Support me with your Amazon purchases:

βš– As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.


Posted by Contributor