SheetFX
≡
<< Go back to all functions

MATCH

The MATCH function in Google Sheets returns the relative position of an item in a range that matches a specified value. This powerful function can be used for various purposes, such as finding the position of a value in a list, performing approximate matches, and more. Explore our comprehensive guide to understand the syntax and usage of the MATCH function.

Function Syntax and Parameters

Syntax: MATCH(search_key, range, [search_type])

Parameters:

  • search_key: The value or reference to the value that you want to search for.
  • range: The range of cells to be searched.
  • [search_type]: [Optional] The type of match to be performed. It can be 1, 0, or -1.

Step-by-Step Tutorial

  1. Exact Match:

    • Example: =MATCH("apple", A1:A5, 0)
    • Result: Returns the position of "apple" in the range A1:A5.

  2. Approximate Match:

    • Example: =MATCH(80, A1:A5, 1)
    • Result: Returns the position of the closest value to 80 in the range A1:A5.

Use Cases and Scenarios

  1. Lookup Values: Find the position of a value in a range.
  2. Data Validation: Check if a value exists in a list.
  3. Sorting and Ranking: Determine the relative position of values.

Related Functions

  • VLOOKUP: Perform vertical lookups in a range.
  • HLOOKUP: Perform horizontal lookups in a range.

Related Articles