Lookup Formulas Training Series – Getting Started with VLOOKUP (1 of 3)

The Lookup Formulas Training Series Part 1:

The 5 Essentials to Getting Started with VLOOKUP

Download the file used in this video:

Getting Started With VLOOKUP.xlsx (432.7 KB)

VLOOKUP Essentials Guide - Excel Campus.pdf (405.5 KB)

Lookup Formulas Training Series

Video 1

Intro to VLOOKUP:
The 5 Must Know Essentials

Video 2

Lookup Formula Errors:
How to Prevent Critical Errors
Coming Soon!

Video 3

An Alternative to VLOOKUP
Coming Soon!


What Are You Going To Use VLOOKUP For?

Please leave a comment below with your answer, and any questions.  Thanks!​


Your email address will not be published. Required fields are marked *

  • I’m rolling my own stock tracking workbook. I’m currently using only VLOOKUP, but I think I’ll benefit by integrating INDEX & MATCH functionality. In the meantime, here’s the evolution of my VLOOKUP:

    Original version:

    Improved—this matches for the current row’s value for BuyID on equivalent column headers

    Better yet! This one matches for the current row’s value for SellID on disparate column headers, e.g., TblTx.Date to tblAnalysis.SellDate