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