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.
99 exercises0 completed
Finds a value and returns its match.
How XLOOKUP worksXLOOKUPFind a Score by StudentUse XLOOKUP to return a numeric score for a student name.BeginnerNot startedXLOOKUPFind an Employee's DepartmentUse XLOOKUP to return text (a department name) for an employee ID.BeginnerNot startedXLOOKUPLook Up Sales by RegionReturn the sales figure for a region using XLOOKUP on a two-column table.BeginnerNot startedXLOOKUPFind a Product's PriceUse XLOOKUP to return the price of a product from a small price list.BeginnerNot startedXLOOKUPReturn a Date for a TaskUse XLOOKUP to return a due date stored as text in YYYY-MM-DD format.BeginnerNot startedXLOOKUPApproximate Match for Grade BandsUse match_mode -1 to find the largest value less than or equal to the lookup value.IntermediateNot startedXLOOKUPExact Match with Custom Not-Found MessageUse XLOOKUP with the if_not_found argument to return a friendly message when a product is missing.IntermediateNot startedXLOOKUPXLOOKUP with IFERROR FallbackWrap XLOOKUP in IFERROR to provide a fallback value when the lookup fails.IntermediateNot startedXLOOKUPReverse Search for Latest RecordUse search_mode -1 to search from the bottom up and return the most recent matching entry.IntermediateNot startedXLOOKUPXLOOKUP Combined with SUM for Total StockCombine XLOOKUP with SUM to total stock across two warehouse columns for a chosen product.IntermediateNot startedXLOOKUPExact Match with Fallback MessageA sales manager wants to look up a product's unit price and show a friendly message when the product is not in the catalog.AdvancedNot startedXLOOKUPClosest Match for Tiered DiscountA pricing clerk wants to find the discount rate that applies to an order total using the nearest lower spending tier.AdvancedNot startedXLOOKUPReverse Search for Latest RecordAn HR assistant needs the most recent salary recorded for an employee when the table is sorted oldest to newest.AdvancedNot startedXLOOKUPConditional Lookup with MAXA warehouse lead wants the highest stock quantity among all entries for a given product code.AdvancedNot startedXLOOKUPTwo-Way Lookup with INDEXA regional analyst needs the sales figure for a specific region and quarter from a cross-tab table.AdvancedNot started