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

Start learning Write review
Boot.dev Ad

The Most Addictive Python and SQL Courses

Learn More → TrainSec Ad

Master Windows Internals - Kernel Programming, Debugging & Architecture

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This tutorial teaches how to use Excel lookup functions to retrieve data from one table and populate another. It covers VLOOKUP, HLOOKUP, INDEX and MATCH, and XLOOKUP through practical examples.

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

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.