Excel 2019: The Ultimate Guide to Excel VLOOKUP
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
- Preview00:59
- 06:32What is Vlookup Function
- 04:00What is Hlookup Function
- 03:08What is Lookup Function
- 03:04Index Match an alternative to VLOOKUP
Instructor
![Excelhub Org](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 139 Reviews
- 13,825 Students
- 1 Course
Excelhub is a portal for learning Microsoft Excel. The portal is sharing knowledge on how to use MS excel, functions, formulas, tricks, VBA and many excel utilities for free for the users. You can get articles videos and excel templates in various sections. The objective is to provide quality education on MS excel in a simple and easily understandable way. The new articles and videos are uploaded to the portal on regular basis.