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





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 of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.