HDTutorial
EN
VLOOKUP Tutorial for Excel - Everything You Need To Know

Playback starts YouTube’s embedded player (privacy-enhanced mode).

VLOOKUP Tutorial for Excel - Everything You Need To Know

2,834,102 views October 25, 2019 21:50

Watch on YouTube
ChannelExcel Campus - Jon

In brief

Master the VLOOKUP function in Excel to quickly search and retrieve data from large tables. This beginner-friendly tutorial covers writing formulas, troubleshooting errors, and advanced techniques like linking tables across sheets—ideal for anyone looking to streamline their spreadsheets.

Key steps

  1. Write a basic VLOOKUP formula by referencing lookup value, table range, column index, and range lookup.
  2. Learn why VLOOKUP stops at the first match and how sorting affects it.
  3. Connect tables or ranges across different sheets using VLOOKUP references.
  4. Use absolute/relative references (F4 or Cmd+T on Mac) to lock or unlock cell references in formulas.

Questions & answers

Does this cover handling errors in VLOOKUP?

Yes, including the IFERROR function for managing errors.

Can I practice with real examples?

The creator provides a free challenge file with exercises and solutions.

Chapters

Description from the creator

Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/

In this video I explain everything you need to know to get started with VLOOKUP for Excel. Download the Excel file: excelcampus.com/wp-content/uploads/2022/06/VLOO…
This tutorial is a follow-along lesson where you will learn to write Vlookup formulas as you watch the video.

It's great for beginners. However, the video is packed with additional tips and tricks for writing formulas that will help save anyone time when writing formulas.

Here are the major topics covered:

00:00 1. What does Vlookup function do and how does it work?
03:26 2. How to write a simple Vlookup formula?
07:54 3. The two main causes of errors with Vlookup.
12:53 4. Vlookup stops at the first match & the sorting myth.
15:07 5. How to create relationships between tables & ranges.
15:55 6. Vlookup to other sheets.

One thing I forgot to mention in the video is the F4 equivalent keyboard shortcut on the Mac version of Excel is Cmd+T. This is for toggling the absolute and relative references when writing the formula.

At the end of the video I mention a bonus challenge (excelcampus.com/vlookup-challenge) that will help you practice and learn additional techniques with Vlookup. This includes:

- The IFERROR function for handling errors.
- Dynamic Vlookup formulas for adding and deleting columns.
- Adding drop-down lists to create interactive spreadsheets.
- Conditional formatting to highlight rows based on a matching value.
- Vlookup with Excel Tables and Structured Reference Formulas.

Please click the link below to download the challenge file and get access to the solution videos. It's free!
👉excelcampus.com/vlookup-challenge


Additional Resources:

Beginner's Guide to Excel Tables: youtu.be/fJnJTff4Na8
Video Series on Pivot Tables & Dashboards: youtu.be/9NUjHBNWe9M
COUNTIF instead of VLOOKUP: youtu.be/ua6qo5gaZ9M

For more tips please subscribe to our free weekly email newsletter:
excelcampus.com/free

#MsExcel #ExcelCampus

About this tutorial

Excel Campus - Jon published this 21:50 video tutorial on October 25, 2019. It has been watched 2,834,102 times on YouTube.

Category
Education
Duration
21:50
Published
October 25, 2019
Views
2,834,102
Likes
50,516

Tags

Share

Further reading

  • VLOOKUP in Excel: Everything You Need to Know professor-excel.com

    Once you’ve found the item, VLOOKUP will look into the same row and return a value in another column on the right hand side. At this point it’s already important to note one of the major restrictions: VLOOKUP can only r…

  • 10 Things You Need to Know About the VLOOKUP Excel Function spreadsheetweb.com

    VLOOKUP Excel function simply searches for a given value in a table, and returns the data from a specific section of that table. The function works in “vertical orientation” (the name stands for “vertical lookup”). For…

  • VLOOKUP Tutorial for Excel – Everything You Need To Know vevodigital.com

    VLOOKUP Tutorial for Excel – Everything You Need To Know Vevo Digital 2020-05-21T18:14:22+08:00 In this video I explain everything you need to know to get started with VLOOKUP for Excel.

This tutorial in other languages