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 Lessons (1h 8m)
    • 1. Introduction To Lookup & Reference Functions

      1:23
    • 2. Working with Named Arrays

      3:30
    • 3. ROW/ROWS & COLUMN/COLUMNS

      3:18
    • 4. VLOOKUP/HLOOKUP

      5:54
    • 5. Joining Data with VLOOKUP

      6:23
    • 6. Fixing Errors with IFERROR & VLOOKUP

      4:30
    • 7. VLOOKUP Reference Array Options

      6:18
    • 8. The INDEX Function

      1:59
    • 9. The MATCH Function

      2:32
    • 10. Using INDEX & MATCH Together

      6:08
    • 11. Combining MATCH with VLOOKUP

      4:47
    • 12. UPDATE: VLOOKUP Correction

      5:05
    • 13. The OFFSET Function

      2:05
    • 14. Combining OFFSET with COUNTA

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

      9:51
    • 16. HOMEWORK: Lookup/Reference Functions

      0:55