Tutoring at Indiana University (IU) in Bloomington, Indiana

Finite math, K201, calculus, and statistics explained

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