---
title: "MATCH in Google Sheets: syntax and examples | ExcelSavvy"
description: "Returns the position of a value in a row or column. Use 0 as match_type for an exact match. With examples and exercises in Google Sheets."
canonical_url: "https://excelsavvy.com/sheets/functions/match"
meta:
  "og:description": "Returns the position of a value in a row or column. Use 0 as match_type for an exact match. With examples and exercises in Google Sheets."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_Returns%2Bthe%2Bposition%2Bof%2Ba%2Bvalue%2Bin%2Ba%2Brow%2Bor%2Bcolumn.%2BUse%2B0%2Bas%2Bmatch__type%2Bfor%2Ban%2Bexact%2Bmatch.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~TUFUQ0gobG9va3VwX3ZhbHVlLCBsb29rdXBfYXJyYXksIFttYXRjaF90eXBlXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL21hdGNoIg%2Cs_Z4RKNLo5OazLE4tM.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "MATCH in Google Sheets: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_Returns%2Bthe%2Bposition%2Bof%2Ba%2Bvalue%2Bin%2Ba%2Brow%2Bor%2Bcolumn.%2BUse%2B0%2Bas%2Bmatch__type%2Bfor%2Ban%2Bexact%2Bmatch.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~TUFUQ0gobG9va3VwX3ZhbHVlLCBsb29rdXBfYXJyYXksIFttYXRjaF90eXBlXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL21hdGNoIg%2Cs_Z4RKNLo5OazLE4tM.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **MATCH in Google Sheets**

Returns the position of a value in a row or column. Use 0 as match\_type for an exact match.

=

MATCH(

## **In Google Sheets**

MATCH takes the same arguments in Google Sheets. The last one defaults to 1, the nearest smaller value in a sorted range, so write 0 for an exact match.

## **How to use MATCH**

MATCH answers the question "which position?" Give it a value and a range, and it returns where the value sits in that range, counting from 1. You do not get the value back, only its place, like learning that a name is fifth on the guest list.

On its own, a position is good for checks. `**=ISNUMBER(MATCH(A2,F2:F20,0))**` tells you whether an invoice number appears on another list at all. Its main job is to feed INDEX: MATCH finds the row, INDEX fetches the value from that row, and together they look up anything in any direction, including to the left, as in `**=INDEX(A2:A20,MATCH(F2,C2:C20,0))**`.

Nearly always, finish with 0 for an exact match. The default of 1 expects data sorted from small to large and returns the last value that is less than or equal to yours, which fits price tiers but not customer IDs. MATCH reads only a single row or column. With 0, text lookups accept wildcards, so `**=MATCH("Ber*",A2:A20,0)**` finds the first name that starts with Ber. The newer XMATCH is exact by default.

## **Syntax**

```
MATCH(lookup_value, lookup_array, [match_type])
```

<dl><dt>**lookup_value **</dt>
<dd>The value to find.</dd>
<dt>**lookup_array **</dt>
<dd>A single row or column to search.</dd>
<dt>**match_type **(optional)</dt>
<dd>0 exact match; 1 (default) largest value less than or equal, in ascending data; -1 smallest value greater than or equal, in descending data.</dd></dl>

## **Examples**

D1`=MATCH(<sup>1</sup>"Pear",<sup>2</sup>A2:A4,<sup>3</sup>0)`

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Fruit | Price |  | **2** |
| 2 | Apple | 4 |  | |
| 3 | Pear | 6 |  | |
| 4 | Plum | 5 |  | |

**In plain words:** Find the position of <sup>1</sup>Pear in <sup>2</sup>the fruit list in A2:A4, <sup>3</sup>only on an exact match.

D1=MATCH(5,B2:B4,0)

|  | A | B | C | D |
| --- | --- | --- | --- | --- |
| 1 | Fruit | Price |  | **3** |
| 2 | Apple | 4 |  | |
| 3 | Pear | 6 |  | |
| 4 | Plum | 5 |  | |

## **Common MATCH mistakes**

- MATCH returns a wrong position or #N/A in an unsorted list

  The last argument is missing, so the default of 1 applies, and that needs ascending data. Add 0 at the end: `**=MATCH(F2,A2:A20,0)**`.
- MATCH returns #N/A even though the value is in the list

  The values only look the same. A trailing space or a number stored as text is the usual cause. Clean the value with `**=MATCH(TRIM(F2),A2:A20,0)**`, or use `**VALUE(F2)**` when the list holds real numbers.
- INDEX and MATCH return the row next to the one I wanted

  The two ranges do not start in the same row. If the INDEX range starts in row 2, the MATCH range must too: `**=INDEX(C2:C20,MATCH(F2,A2:A20,0))**`. Including the header row in only one of them shifts the position by one.
- MATCH returns #N/A when I select a whole table

  MATCH reads only one row or one column. Point it at the single column that holds the keys, such as `**A2:A20**`, not `**A2:C20**`.

## **Practice MATCH**

- [**1****Find a position with MATCH**→](https://excelsavvy.com/sheets/practice/index-match/match-function)
- [**2****Look up a price with INDEX and MATCH**→](https://excelsavvy.com/sheets/practice/index-match/index-match)
- [**3****Look to the left with INDEX and MATCH**→](https://excelsavvy.com/sheets/practice/index-match/index-match-left-lookup)
- [**4****A two-way lookup with INDEX and two MATCHes**→](https://excelsavvy.com/sheets/practice/index-match/index-match-match-two-way)

## **Related functions**

- [**INDEX**](https://excelsavvy.com/sheets/functions/index)
- [**XMATCH**](https://excelsavvy.com/functions/xmatch)
- [**XLOOKUP**](https://excelsavvy.com/sheets/functions/xlookup)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/sheets/functions/match#webpage","@type":"WebPage","dateModified":"2026-11-16","description":"Returns the position of a value in a row or column. Use 0 as match_type for an exact match. With examples and exercises in Google Sheets.","name":"MATCH in Google Sheets: syntax and examples","url":"https://excelsavvy.com/sheets/functions/match","breadcrumb":{"@id":"https://excelsavvy.com/sheets/functions/match#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/sheets/functions/match"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/sheets/functions/match#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Google Sheets practice exercises","item":"https://excelsavvy.com/sheets","position":2},{"@type":"ListItem","name":"MATCH in Google Sheets: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/sheets/functions/match#article","dateModified":"2026-11-16","description":"Returns the position of a value in a row or column. Use 0 as match_type for an exact match. With examples and exercises in Google Sheets.","headline":"MATCH in Google Sheets: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_Returns%2Bthe%2Bposition%2Bof%2Ba%2Bvalue%2Bin%2Ba%2Brow%2Bor%2Bcolumn.%2BUse%2B0%2Bas%2Bmatch__type%2Bfor%2Ban%2Bexact%2Bmatch.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~TUFUQ0gobG9va3VwX3ZhbHVlLCBsb29rdXBfYXJyYXksIFttYXRjaF90eXBlXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL21hdGNoIg%2Cs_Z4RKNLo5OazLE4tM.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/sheets/functions/match#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/sheets/functions/match#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_Returns%2Bthe%2Bposition%2Bof%2Ba%2Bvalue%2Bin%2Ba%2Brow%2Bor%2Bcolumn.%2BUse%2B0%2Bas%2Bmatch__type%2Bfor%2Ban%2Bexact%2Bmatch.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~TUFUQ0gobG9va3VwX3ZhbHVlLCBsb29rdXBfYXJyYXksIFttYXRjaF90eXBlXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL21hdGNoIg%2Cs_Z4RKNLo5OazLE4tM.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogc3ludGF4IGFuZCBleGFtcGxlcw%2Cdescription_Returns%2Bthe%2Bposition%2Bof%2Ba%2Bvalue%2Bin%2Ba%2Brow%2Bor%2Bcolumn.%2BUse%2B0%2Bas%2Bmatch__type%2Bfor%2Ban%2Bexact%2Bmatch.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~TUFUQ0gobG9va3VwX3ZhbHVlLCBsb29rdXBfYXJyYXksIFttYXRjaF90eXBlXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL21hdGNoIg%2Cs_Z4RKNLo5OazLE4tM.png"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
