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.

⌚ 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

👋 Additional resources:

• Sample file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whK4bP…

Subscribe: https://www.youtube.com/channel/UCfJT_eYDTmDE-ovKaxVE1ig

#excel