VLOOKUP in Excel

Using & Troubleshooting VLOOKUP
Course Created by Bill Jelen
Host of MrExcel.com website. Microsoft MVP in Excel for 10 years. Author of 43 books about Microsoft Excel and a frequent speaker at accounting conferences.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

VLOOKUP is Excel's most powerful function - when all of you co-workers are using VLOOKUP, this course will get you up to speed.

Course Objectives

  • Use VLOOKUP in Excel
  • Troubleshoot when VLOOKUP is returning #N/A errors.
  • Know when to use INDEX & MATCH instead of VLOOKUP
  • Learn advanced VLOOKUP tricks

Who Is This For?

  • Anyone using Excel
  • Financial Analysts
  • Marketing Analysts
  • Financial Modelers

Course Outline

Chapter 1: Creating your first VLOOKUP in Excel

  • Lesson 1
    Intro
    02:19
  • Lesson 2
    Basics
    05:12

Chapter 2: Troubleshooting VLOOKUP

  • Lesson 3
    Troubleshooting VLOOKUP
    11:19

Chapter 3: Alternatives to VLOOKUP

  • Lesson 4
    Alternatives
    03:07

Chapter 4: Special Situations with VLOOKUP

  • Lesson 5
    Tricks to Make Special Situ…
    13:38

Chapter 5: Going beyond VLOOKUP to INDEX & MATCH

  • Lesson 6
    INDEX and MATCH
    11:59

Chapter 6: Using VLOOKUP

  • Lesson 7
    TwoLists
    03:19
  • Lesson 8
    PasteValues
    02:17
  • Lesson 9
    Range Lookup - When to use …
    05:29

Chapter 7: Advanced Topics

  • Lesson 10
    Last Match
    03:02
  • Lesson 11
    Advanced Examples
    03:53
  • Lesson 12
    INDIRECT function
    02:21
  • Lesson 13
    CHOOSE Function
    01:01
  • Lesson 14
    Wrap-Up
    02:13
  • Lesson 15
    Excel VLOOKUP Tip Card

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)