Excel Formulas & Functions Part 5: Lookup & Reference Functions

Chris Dutton, Founder, Excel Maven

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
16 Videos (1h 8m)
    • Introduction To Lookup & Reference Functions

      1:23
    • Working with Named Arrays

      3:30
    • ROW/ROWS & COLUMN/COLUMNS

      3:18
    • VLOOKUP/HLOOKUP

      5:54
    • Joining Data with VLOOKUP

      6:23
    • Fixing Errors with IFERROR & VLOOKUP

      4:30
    • VLOOKUP Reference Array Options

      6:18
    • The INDEX Function

      1:59
    • The MATCH Function

      2:32
    • Using INDEX & MATCH Together

      6:08
    • Combining MATCH with VLOOKUP

      4:47
    • UPDATE: VLOOKUP Correction

      5:05
    • The OFFSET Function

      2:05
    • Combining OFFSET with COUNTA

      2:58
    • PROJECT SHOWCASE: Using OFFSET to Create a Dynamic Scrolling Chart

      9:51
    • HOMEWORK: Lookup/Reference Functions

      0:55