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

Learn how to effectively use essential lookup functions in Microsoft Excel through this hour-long tutorial. The course covers VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP functions. By the end of the course, you will be able to perform exact and approximate matches, work with expanding data, combine different lookup functions, and utilize the powerful XLOOKUP function. The teaching method involves step-by-step demonstrations with practical examples. This course is suitable for Excel users looking to enhance their lookup skills and efficiency in data analysis.

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.