Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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 Videos (11m)
    • Indexmatchintro

    • 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






Reviews (0)

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