Autoplay
Autocomplete
Previous Lesson
Complete and Continue
EXCEL VLOOKUP FUNCTION
Introduction to the Course
Introduction to the Course (3:16)
VLOOKUP
Introduction to VLOOKUP (8:05)
VLOOKUP with Column Reference (4:09)
VLOOKUP with Range Name (4:39)
VLOOKUP with Table (5:20)
VLOOKUP with INDIRECT (11:23)
VLOOKUP with VALUE for Data Type Mismatch (5:37)
VLOOKUP with unclean names (2:38)
VLOOKUP with IFERROR (4:23)
VLOOKUP with Column Number Picker (3:04)
VLOOKUP with Multiple Column Search (1:21)
VLOOKUP based on Two Tables (2:29)
VLOOKUP based on Multiple Sheets (9:28)
VLOOKUP with results from Multiple Columns (5:05)
VLOOKUP with results from Multiple Columns - Advanced (3:39)
VLOOKUP with Approximate Match (4:25)
VLOOKUP with SUM (1:47)
VLOOKUP with Approximate Match without Table Array (4:38)
VLOOKUP with Approximate Match - Advanced (9:30)
VLOOKUP with Duplicate Values (6:12)
INDEX and MATCH
INDEX Function (5:50)
MATCH Function (4:20)
MATCH Function with match type (5:14)
INDEX + MATCH as replacement for VLOOKUP (12:06)
INDEX + MATCH for Data Type Mismatch (3:04)
INDEX + MATCH for Multi Column Search (3:33)
INDEX + MATCH with Case Sensitivity (3:08)
XLOOKUP
Introduction to XLOOKUP (9:12)
XLOOKUP with Multi Column Results (1:42)
XLOOKUP with Multi Column Search (1:38)
BONUS
The OFFSET Function (13:48)
The INDIRECT Function (4:31)
Get Your Certificate
SOLUTIONS
SOLUTIONS
VLOOKUP with INDIRECT
Download
VLOOKUP with INDIRECT.xlsx
Complete and Continue