Excel 2019: The Ultimate Guide to Excel VLOOKUP
4.1 (46 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,221 students enrolled

Excel 2019: The Ultimate Guide to Excel VLOOKUP

15 Essential things you should know about LOOKUP functions
4.1 (46 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,221 students enrolled
Created by Excelhub Org
Last updated 5/2019
English
English [Auto-generated]
Current price: $23.99 Original price: $34.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 17 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Ultimate Guide to Excel Vlookup
  • Learn Vlookup Basics to Pro
  • 15 Essential things you should know about LOOKUP
  • lookup functions VLOOKUP, HLOOKUP INDEX MATCH
  • Vlookup to solve many problems
Requirements
  • Basic Knowledge of Excel
  • Be able to use basic excel functions
Description

Learn Basics to Advanced use of excel VLOOKUP function.

This course is on MS Excel VLOOKUP function. In this course, you will learn from basics to advance use of VLOOKUP. Alongwith this you will also understand what you can do and what you can't do with the VLOOKUP function. In addition to VLOOKUP function, you will also learn how to use other LOOKUP functions like, HLOOKUP, LOOKUP, INDEX MATCH, etc.

This course is recorded with the latest version of Excel 2019. All the lectures are explained with the examples and you can download all these excel files and practice the formulas.

You will also learn below mentioned most important excel tricks which will help you to give easy solutions to problems you face in applying LOOKUP formulas.

  • Use of wildcard in VLOOKUP

  • VLOOKUP to the Left

  • Nested VLOOKUP Trick

  • VLOOKUP Multiple Criteria

  • VLOOKUP Auto Update Column Number

  • VLOOKUP to Replace Nested IF Formula

  • LOOKUP Picture instead of Data

  • VLOOKUP Different Sheets with Same Formula

  • 2D LOOKUP with VLOOKUP

  • 3D LOOKUP with VLOOKUP

  • VLOOKUP Multiple Tables

  • Speedup Your VLOOKUP Formula

  • Case Sensitive LOOKUP for Exact Match

  • How to Use VLOOKUP in VBA

  • Handle VLOOKUP Errors

The course is presented in an easy to follow step by step approach. Any one with basic excel knowledge and vlookup function can learn all these tricks with the help of this course.


Enroll now and take the action to become master in excel LOOKUP!

Who this course is for:
  • Vlookup
  • Office productivity
  • MS Excel
  • MS office
  • Excel vlookup
Course content
Expand all 21 lectures 01:36:32
+ Introduction
5 lectures 17:43
What is Vlookup Function
06:32
What is Hlookup Function
04:00
What is Lookup Function
03:08
Index Match an alternative to VLOOKUP
03:04
+ 15 Essential things you should know about LOOKUP
15 lectures 01:08:25

You can download the example file below

Preview 06:35

You can download the example file below

Preview 06:23

You can download the example file below

Nested VLOOKUP Trick
04:50

You can download the example file below

VLOOKUP Multiple Criteria
06:55

You can download the example file below

VLOOKUP Auto Update Column Number
03:15

You can download the example file below

VLOOKUP to Replace Nested IF Formula
03:29

You can download the example file below

LOOKUP Picture instead of Data
03:59

You can download the example file below

VLOOKUP Different Sheets with Same Formula
05:05

You can download the example file below

2D LOOKUP with VLOOKUP
02:11

You can download the example file below

3D LOOKUP with VLOOKUP
05:35

You can download the example file below

VLOOKUP Multiple Tables
03:18

You can download the example file below

Speedup Your VLOOKUP Formula
02:19

You can download the example file below

Case Sensitive LOOKUP for Exact Match
04:10

You can download the example file below

How to Use VLOOKUP in VBA
05:34

You can also read more details in our blog

How to Correct VLOOKUP error

https://excelhub.org/how-to-correct-vlookup-error/

Handle VLOOKUP Errors
04:47
+ Bonus Topic
1 lecture 10:24
Bonus: 11 awesome tricks in excel
10:24