Exact lookup using VLOOKUP Function in Microsoft Excel

This course will enable you to master one of the most useful Microsoft Excel function VLOOKUP.
Rating: 4.2 out of 5 (580 ratings)
6,130 students
Exact lookup using VLOOKUP Function in Microsoft Excel
Rating: 4.2 out of 5 (580 ratings)
6,131 students
Understand VLOOKUP Function of Microsoft Excel
How to exact lookup any value from a large table
Using lookup table from other sheet
Using lookup table from other workbook

Requirements

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

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.

Who this course is for:
  • Microsoft Excel users
  • Microsoft Excel users who want to have grip on VLOOKUP Function of Microsoft Excel
Curriculum
6 sections • 12 lectures • 35m total length
  • Introduction to VLOOKUP
  • Syntax of VLOOKUP
  • Writing your first VLOOKUP Function
  • Writing VLOOKUP with Absolute Reference for Lists
  • Using Range Lookup for VLOOKUP Function
  • Writing a multi-sheet VLOOKUP
  • Writing VLOOKUP in a multi-workbook setup.
  • VLOOKUP with MATCH
  • VLOOKUP with IFERROR
  • VLOOKUP with wildcards
  • VLOOKUP multiple columns
  • VLOOKUP for specific occurrence

Instructor
Nooruddin Surani
  • 4.2 Instructor Rating
  • 620 Reviews
  • 9,474 Students
  • 2 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!