Practical Fundamentals of Index and Match in Excel and Google Sheets

Paula Guilfoyle, CPA, Online Educators, Lifelong Learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
2 Lessons (11m)
    • 1. Indexmatchintro

      0:30
    • 2. 2indexmatch

      10:27

About This Class

f7a049c6

Index and Match are both reference function in Excel and Google Sheets. If you combine both of these you will create a robust and dynamic two way lookup, to return values that you need.These are functions that should be mastered by every intermediate Excel or Google Sheets user.

In this class you will learn about the Index and Match, the syntax, how it works, and how to combine them in a formula to make a powerful lookup