Download the Example Files

You cannot view this unit as you're not logged in yet.

Master Excel Lookups and References

Module 1	First Things First	-
Unit 1	Before You Begin
Unit 2	Download the Example Files
Unit 3	Excel Cell References - Relative vs. Absolute
Module 2	Excel VLOOKUP Function	+
Unit 1	VLOOKUP Function Overview
Unit 2	VLOOKUP With Approximate Match
Unit 3	VLOOKUP With Exact Match 1
Unit 4	VLOOKUP With Exact Match 2
Unit 5	VLOOKUP With Exact Match 3
Unit 6	Excel Named Ranges - Overview
Unit 7	VLOOKUP With a Named Range
Unit 8	Excel Tables - Overview
Unit 9	VLOOKUP With an Excel Table
Unit 10	VLOOKUP Exercise - Assignment
Unit 11	VLOOKUP Exercise - Solution
Module 3	Excel HLOOKUP Function	+
Unit 1	Excel's HLOOKUP Function - Overview
Unit 2	HLOOKUP Exercise - Assignment
Unit 3	HLOOKUP Exercise - Solution
Module 4	Excel MATCH Function	+
Unit 1	Excel MATCH Function Overview
Unit 2	VLOOKUP and MATCH Combined - 1
Unit 3	VLOOKUP and MATCH Combined - 2
Unit 4	HLOOKUP and MATCH Combined
Module 5	INDEX and MATCH	+
Unit 1	INDEX Function Overview 1 - Rows and Columns
Unit 2	INDEX Function Overview 2 Rows only or Columns only
Unit 3	INDEX Function Overview 3 - Reference Form
Unit 4	INDEX and MATCH 1 - One-Dimensional Lookup
Unit 5	INDEX and MATCH 2 - Two-Dimensional Lookup
Unit 6	INDEX and MATCH 3 - Two-Dimensional Lookup
Unit 7	INDEX and MATCH Exercise 1 - Assignment
Unit 8	INDEX and MATCH Exercise 1 - Solution
Unit 9	INDEX and MATCH Exercise 2 - Assignment
Unit 10	INDEX and MATCH Exercise 2 - Solution
Unit 11	Array Formulas - Introduction
Unit 12	INDEX and MATCH in Array Formulas
Unit 13	How to TRANSPOSE Data in Excel
Unit 14	INDEX, MATCH, TRANSPOSE Array
Unit 15	VLOOKUP with Named Arrays
Module 6	OFFSET Function	+
Unit 1	OFFSET Function - Overview
Unit 2	OFFSET - Dynamic SUM Range
Module 7	INDIRECT Function	+
There are no units in this module.