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
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 startedXLOOKUPLook Up Sales by RegionReturn the sales figure for a region using XLOOKUP on a two-column table.BeginnerNot startedXLOOKUPFind an Employee's DepartmentUse XLOOKUP to return text (a department name) for an employee ID.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 startedXLOOKUPXLOOKUP with IFERROR FallbackWrap XLOOKUP in IFERROR to provide a fallback value when the lookup fails.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 startedXLOOKUPApproximate Match for Grade BandsUse match_mode -1 to find the largest value less than or equal to the lookup value.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 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 startedXLOOKUPTwo-Way Lookup with INDEXA regional analyst needs the sales figure for a specific region and quarter from a cross-tab table.AdvancedNot 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 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 started