Exact lookup using VLOOKUP Function in Microsoft Excel

This course will enable you to master one of the most useful Microsoft Excel function VLOOKUP with simple Examples.
Rating: 4.1 out of 5 (899 ratings)
9,783 students

Understand VLOOKUP Function of Microsoft Excel
How to exact lookup any value from a large table
Using VLOOKUP table from other sheet
How to do Wildcard matches in VLOOKUP
Using VLOOKUP table from other workbook
Using VLOOKUP for Specific Occurence


  • Understanding Excel
  • Use Excel's basic formulas & functions


VLOOKUP is probably the most used function in excel. In this VLOOKUP course, We introduces you to the most simplest way to understand VLOOKUP function.

This course starts  with understanding of VLOOKUP syntax. Then it will show you how to use VLOOKUP function is a List, Multi-Sheet / Multi-Workbook and then gradually moves to the using of VLOOKUP with other functions.

This course will fully benefit, if you download the exercise files, and practice it yourself.

I always tell my students that learning Microsoft Excel is like driving, you can't learn it till you drive yourself, so it is totally true for Microsoft Excel, that you don't learn it till the time you do it yourself, hands-on.

By the completion of this course, you will be fully versed, and capable of using VLOOKUP function in Microsoft Excel.

Who this course is for:

  • Microsoft Excel users
  • Microsoft Excel users who want to have grip on VLOOKUP Function of Microsoft Excel


Nooruddin Surani
  • 4.1 Instructor Rating
  • 1,172 Reviews
  • 15,615 Students
  • 3 Courses

  Nooruddin Surani is an MBA in MIS, a Microsoft Certified Trainer for Office 2007 Master Program, Microsoft Excel 2010, Microsoft Excel 2013, Brainbench Master Certified for Excel 2007 (ranking 4 in world) and a Certified Information Systems Auditor (CISA). His vibrant personality combined with a unique blend of content and delivery makes the participants’ experience both educating and entertaining. 

  Surani has been associated with the application of Information Technology for more than 18 years and is actively involved in training and teaching as a visiting faculty with multiple reputable institutes. 

  Surani’s unique experience of working with the corporate sector includes designing & development of software solutions for medium to large sized industries, retail business management, educational, financial and banking institutions. After being engaged in consultancy assignments for leading organizations, Surani is thoroughly able to inspire and encourage those around him through his unique training style which enables maximum learning & retention in least possible time. 

  Besides being an ardent trainer, Surani also has to his credit several articles published in multiple IT related publications. Currently, he is working as the Chief Operating Officer at Viftech Solutions (Pvt.) Ltd., a software & information technology solution provider. Driven by a mission in life, Surani aims to provide better understanding to his participants enabling them to focus better and achieve the results they seek!