Preview Vlookup and XLookup Mastery

Introduction to Formulas

Working with Cell References - Relative

Working with Cell References - Multiple Cells

Relative Vs Fixed Referencing

Practice Files

Vlookup within Same File - Text Data Reference

Vlookup

Introduction to VLookup

VLOOKUP() For Text Information

VLOOKUP() on Date Information

VLOOKUP() with two or more Excel Files

VLOOKUP() with Approximate Match

VLOOKUP() on Complex Dataset

Common Mistakes and Errors when using Lookup Formulas

XLookup

Introduction to XLookup

XLOOKUP() on Simple Data

XLOOKUP() on Multiple Files of reference

XLOOKUP() on Date and Horizontal Data

XLOOKUP() with Match mode of Higher Value

XLOOKUP() with Match mode of Lower Value

XLOOKUP() with Match mode of Wildcard Characters

Index and Match

Introduction to Match Formula

Introduction to Index Formula

Index and Match Formulas Together