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
Looks down the first column.
How VLOOKUP worksVLOOKUPFind a Product PriceUse VLOOKUP to look up the price of a product from a small price list.BeginnerNot startedVLOOKUPLook Up a Student ScoreRetrieve a student's exam score by looking up their name in a marks table.BeginnerNot startedVLOOKUPFind an Employee DepartmentUse VLOOKUP to return text (a department name) for a given employee ID.BeginnerNot startedVLOOKUPLook Up a City's PopulationRetrieve a numeric value from a city table using an exact-match VLOOKUP.BeginnerNot startedVLOOKUPFind a Book's Shelf CodeUse VLOOKUP to return a text code for a book title from a small catalogue.BeginnerNot startedVLOOKUPApproximate Match for Grade BandsUse an approximate match to assign a letter grade from a score threshold table.IntermediateNot startedVLOOKUPVLOOKUP with SUM for Total Stock ValueCombine VLOOKUP with SUM to total the stock value of two products.IntermediateNot startedVLOOKUPVLOOKUP with LEFT for Code LookupExtract a category code from a product ID and look up its category name.IntermediateNot startedVLOOKUPExact Match with IFERROR FallbackLook up a product's price and return a friendly message if the product is missing.IntermediateNot startedVLOOKUPVLOOKUP with IF for Conditional BonusLook up an employee's sales and return a bonus only if sales exceed the target.IntermediateNot startedVLOOKUPCommission Lookup with IFA sales manager needs to calculate the commission for a specific salesperson based on their sales total.AdvancedNot startedVLOOKUPPrice Times Quantity with VLOOKUPA warehouse clerk needs the total value of an order line by combining a looked-up unit price with a quantity.AdvancedNot startedVLOOKUPBonus Eligibility with IF and VLOOKUPAn HR analyst wants to flag employees eligible for a bonus based on their performance rating.AdvancedNot startedVLOOKUPDiscount Tier Lookup with ROUNDA pricing analyst needs the discounted price for a product after applying a percentage discount from a lookup table.AdvancedNot startedVLOOKUPStock Reorder Check with IF and VLOOKUPAn inventory manager wants to know how many units to reorder when stock falls below a reorder level.AdvancedNot started