Video Lesson

Lookup Functions

Pro

Learn the lookup mental model, how X lookup's match and search modes work, when index + X match is cleaner, and why legacy lookup functions are more limited.

This is a Pro lesson

Get Pro to unlock this lesson, the full course, and all site features.

See Pro Details

Want to sample the course first? Try the free Conditional Aggregation video lesson and quiz.

Try Free Lesson Try Free Quiz

Video Lesson Workbook

The reference workbook for this lesson is included with Pro.

See Pro Details