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
Position of a value in a list.
How MATCH worksMATCHPosition of a cityUse MATCH to find where a city appears in a short list of cities.BeginnerNot startedMATCHPosition of a code numberUse MATCH to locate a numeric code in a column of codes.BeginnerNot startedMATCHFind a product's positionUse MATCH to find the row position of a product in a short product list.BeginnerNot startedMATCHPosition of a sales figureUse MATCH with an exact match to locate a specific sales number in a column.BeginnerNot startedMATCHFind a name's positionUse MATCH to return the position of a person's name in a list of names.BeginnerNot startedMATCHExact Match Position in a Product ListUse MATCH with match_type 0 to find the position of a product in an unsorted list.IntermediateNot startedMATCHApproximate Match in a Sorted Score TableUse MATCH with match_type 1 to find the position of the largest score not exceeding a threshold.IntermediateNot startedMATCHMATCH Combined with INDEX to Retrieve a PriceCombine MATCH with INDEX to look up a product's price by finding its position first.IntermediateNot startedMATCHMATCH Combined with ISNUMBER to Find a Numeric EntryUse MATCH with ISNUMBER to locate the first cell in a mixed list that contains a number.IntermediateNot startedMATCHMATCH Combined with COUNTIF for a Duplicate CheckUse MATCH to find the first occurrence position and COUNTIF to confirm how many times a value appears.IntermediateNot startedMATCHFind the rank position of a sales figureA sales manager wants to know where a specific sales total sits in an unsorted list of regional sales.AdvancedNot startedMATCHLocate an employee's row in a rosterAn HR coordinator needs the row position of an employee in an alphabetical staff list to reference other data.AdvancedNot startedMATCHPosition of the highest score using MAX inside MATCHA training lead wants the position of the top exam score in a list of trainee results.AdvancedNot startedMATCHFind a product's position and pull its price with INDEXA buyer wants the price of a product by first finding its position and then retrieving the price.AdvancedNot startedMATCHApproximate position for a discount tierA pricing analyst needs the tier position for an order quantity using an approximate match on sorted thresholds.AdvancedNot started