blog home

GP7 - Lookup Functions - VLOOKUP, HLOOKUP, MATCH, and INDEX

Subject: Business, Information Systems
Courses: K201
Posted by: Dalia

One of the more powerful features of Excel is its collection of lookup functions, which let you cross-reference tabular data in your spreadsheets. K201 students sometimes find them tricky to master though, especially when it comes to determining when to use a VLOOKUP, HLOOKUP, or INDEX-MATCH formula.

In this video for GP7, Dalia goes over examples for each of these formulas - you'll be done in no time!

Download the exercise files