Exercise catalogue

Choose a category

Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.

386 exercises0 completed

Find and return data: XLOOKUP, VLOOKUP, INDEX/MATCH, FILTER, SORT, UNIQUE.

MATCHPosition of a value in a list15 exercisesBIA0/15 VLOOKUPLooks down the first column15 exercisesBIA0/15 XLOOKUPFinds a value and returns its match15 exercisesBIA0/15 INDEXValue at a row and column14 exercisesBIA0/14

Looking for another lookup function? See all lookup & reference functions.