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: https://1drv.ms/x/s!AmxrofZZlZ-whK4bP…
• 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