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

Practical Fundamentals of VLookup 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. Basicvlookupintro

    • 2. Vlookup


About This Class


VLookup is a powerful and versatile function in Excel and Google Sheets that can be combined with many other functions and formula. It is a function that should be mastered by every intermediate Excel or Google Sheets user.

In this class you will learn about the basic VLookup, the syntax, how it works, and how to do a VLookup in Excel with both an exact and an approximate match.

An example where VLOOKUP might be useful is if you have a monthly sales report in Excel, and want to find the sales made by a specific salesperson from within a monthly sales report. You would lookup the the person's name in the Salesperson column, and then look in the Sales column to find that person's sales for the month.

On completion of the class project, you will be ready to move on to a more advanced VLookup course, such as VLookup and Text or Index and Match. Check out my profile to see what other classes I have on this and other topics.......





  • --
  • 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