Ultimate Excel Course #5 - Lookup Functions: The Powerful VLOOKUP Function and Beyond - Skillshare

Ultimate Excel Course #5 - Lookup Functions: The Powerful VLOOKUP Function and Beyond

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Videos (39m)
    • Introduction

      1:41
    • The VLOOKUP Function Explained

      7:04
    • Using VLOOKUP for a Range Lookup

      5:09
    • Advanced VLOOKUP with a Dynamic Column Index Number

      8:42
    • Handling Errors with your Lookup Formulas

      5:23
    • INDEX and MATCH Combo for a Versatile Lookup Formula

      6:20
    • Two Way Lookup using INDEX and MATCH

      4:15
    • Thank You

      0:19
13 students are watching this class