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

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

5 of 5 students recommendSee All

Easy to understand.
Excellent short course on how to use a Vlookup. Made it very easy to understand and use.





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