Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Lookup Functions in Excel - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

Simon Sez IT via YouTube

Overview

Master essential Excel lookup functions in this comprehensive hour-long tutorial. Learn to use VLOOKUP for exact and approximate matches, handle expanding data, and apply HLOOKUP effectively. Explore advanced techniques by combining VLOOKUP with MATCH, and discover the power of INDEX, MATCH, and XLOOKUP as versatile alternatives. Follow along with downloadable Excel files to practice each concept, including exact and approximate matching, expanding data scenarios, and horizontal lookups. Gain practical skills to enhance your data analysis and spreadsheet management capabilities, making this tutorial invaluable for Excel users seeking to improve their lookup function proficiency.

Syllabus

- Vlookup Exact Match
- Vlookup Approximate Match
- Vlookup with Expanding Data
- Using Hlookup
- Combining Vlookup and Match
- Using Index, Match and Xlookup

Taught by

Simon Sez IT

Reviews

Start your review of Lookup Functions in Excel - VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.