Match formula google sheets: A Practical Guide
Master the MATCH formula in Google Sheets: perform exact and approximate lookups, blend it with INDEX for robust results, and debug errors with examples.
How To Sheets Team
·5 min read
Understanding the MATCH function in Google Sheets
The MATCH function locates the position of a search key within a one-dimensional range. It accepts three arguments: search_key, range, and match_type (optional). The most common usage is with an exact match (0). When the data is sorted, you can use 1 for a less-than match or -1 for a greater-than match. This flexibility makes MATCH ideal for dynamic lookups and as a building block for more complex formulas.
Excel Formula
=MATCH("Apples", A2:A100, 0) // exact matchExcel Formula
=MATCH(105, B2:B100, 1) // approximate match (requires ascending sort)Excel Formula
=INDEX(C2:C100, MATCH("Apples", A2:A100, 0)) // fetch corresponding value from column C- Parameters:
- search_key: value to locate (text, number, or a formula)
- range: one-dimensional range to search (vertical column or horizontal row)
- match_type: 0 for exact, 1 for less-than, -1 for greater-than
- Returns: the position (row or column index) within the range; use with INDEX for value retrieval.