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!