Practical Fundamentals of Index and Match in Excel and Google Sheets | Paula Guilfoyle | Skillshare

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

    • 2. 2indexmatch


About This Class


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





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Paula Guilfoyle

CPA, Online Educators, Lifelong Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has courses for those wishing to up skill, especially in the area o...

See full profile

Report class