EXCEL VLOOKUP
0.0 (0 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.
0 students enrolled

EXCEL VLOOKUP

THE ONLY GUIDE YOU WILL EVER NEED!
New
0.0 (0 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.
0 students enrolled
Created by Havish Madhvapaty
Last updated 5/2020
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 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
  • VLOOKUP, INDEX, MATCH, XLOOKUP, OFFSET, INDIRECT
Requirements
  • Basic Excel Knowledge
Description

Did you know VLOOKUP is the third most used function on #excel after SUM and AVERAGE?   (Microsoft research)


Think you know VLOOKUP well?   :)

Prepare to look again with a fresh pair of eyes!


Glad to offer the MASTER GUIDE on VLOOKUP.



3 hour course for INR 500

30 + Lectures | Lifetime Access | All solutions provided


Everything you need to Excel at VLOOKUP.

Work like never before!


Covers:

VLOOKUP with Column Reference

VLOOKUP with Range Name

VLOOKUP with Table

VLOOKUP with INDIRECT

VLOOKUP with VALUE for Data Type Mismatch

VLOOKUP with unclean names

VLOOKUP with IFERROR

VLOOKUP with Column Number Picker

VLOOKUP with Multiple Column Search

VLOOKUP based on Two Tables

VLOOKUP based on Multiple Sheets

VLOOKUP with results from Multiple Columns

VLOOKUP with SUM

VLOOKUP with Approximate Match

VLOOKUP with Approximate Match without Table Array

VLOOKUP with Approximate Match - Advanced

VLOOKUP with Duplicate Values

INDEX Function

MATCH Function

MATCH Function with match type

INDEX + MATCH as replacement for VLOOKUP

INDEX + MATCH for Data Type Mismatch on both sides

INDEX + MATCH for Multi Column Search

INDEX + MATCH with Case Sensitivity

Introduction to XLOOKUP

XLOOKUP with Multi Column Results

XLOOKUP with Multi Column Search

The OFFSET Function

The INDIRECT Function

Who this course is for:
  • Working Professionals
  • Management Students
Course content
Expand all 31 lectures 02:45:35
+ VLOOKUP
18 lectures 01:34:13
Introduction to VLOOKUP
08:05
VLOOKUP with Column Reference
04:09
VLOOKUP with Range Name
04:39
VLOOKUP with Table
05:20
VLOOKUP with VALUE for Data Type Mismatch
05:37
VLOOKUP with unclean names
02:38
VLOOKUP with IFERROR
04:23
VLOOKUP with Column Number Picker
03:04
VLOOKUP with Multiple Column Search
01:21
VLOOKUP based on Two Tables
02:29
VLOOKUP based on Multiple Sheets
09:28
VLOOKUP with results from Multiple Columns
05:05
VLOOKUP with Approximate Match
04:25
VLOOKUP with Approximate Match without Table Array
04:38
VLOOKUP with Approximate Match - Advanced
09:30
VLOOKUP with Duplicate Values
06:12
+ INDEX and MATCH
7 lectures 37:15
INDEX Function
05:50
MATCH Function
04:20
MATCH Function with match type
05:14
INDEX + MATCH as replacement for VLOOKUP
12:06
INDEX + MATCH for Data Type Mismatch on both sides
03:04
INDEX + MATCH with Case Sensitivity
03:08
+ XLOOKUP
3 lectures 12:32
Introduction to XLOOKUP
09:12
XLOOKUP with Multi Column Results
01:42
XLOOKUP with Multi Column Search
01:38
+ ADDITIONAL: OFFSET AND INDIRECT
2 lectures 18:19
The OFFSET Function
13:48
The INDIRECT Function
04:31