---
title: "INDEX MATCH in Google Sheets: practice exercises | PracticeExcel"
description: "Practice INDEX and MATCH in Google Sheets, including lookups to the left, in exercises that are checked as you type."
canonical_url: "https://practiceexcelonline.com/sheets/practice/index-match"
locale: en
meta:
  "og:description": "Practice INDEX and MATCH in Google Sheets, including lookups to the left, in exercises that are checked as you type."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SU5ERVggTUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogcHJhY3RpY2UgZXhlcmNpc2Vz%2Cdescription_~UHJhY3RpY2UgSU5ERVggYW5kIE1BVENIIGluIEdvb2dsZSBTaGVldHMsIGluY2x1ZGluZyBsb29rdXBzIHRvIHRoZSBsZWZ0LCBpbiBleGVyY2lzZXMgdGhhdCBhcmUgY2hlY2tlZCBhcyB5b3UgdHlwZS4%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiUHJpY2UiLCJQcm9kdWN0IiwiUG9zaXRpb24iXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZXMiLCIyMiIsIkRhdGVzIiwiIl19LHsibiI6MywiY2VsbHMiOlsiQmFuYW5hcyIsIjE4IiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiQ2hlcnJpZXMiLCI0NSIsIiIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkRhdGVzIiwiMzgiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJGaWdzIiwiNiIsIiIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9zaGVldHMvcHJhY3RpY2UvaW5kZXgtbWF0Y2gi%2Cs_ZWqa1BBDxoOZK0St.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "INDEX MATCH in Google Sheets: practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~SU5ERVggTUFUQ0ggaW4gR29vZ2xlIFNoZWV0czogcHJhY3RpY2UgZXhlcmNpc2Vz%2Cdescription_~UHJhY3RpY2UgSU5ERVggYW5kIE1BVENIIGluIEdvb2dsZSBTaGVldHMsIGluY2x1ZGluZyBsb29rdXBzIHRvIHRoZSBsZWZ0LCBpbiBleGVyY2lzZXMgdGhhdCBhcmUgY2hlY2tlZCBhcyB5b3UgdHlwZS4%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiUHJpY2UiLCJQcm9kdWN0IiwiUG9zaXRpb24iXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZXMiLCIyMiIsIkRhdGVzIiwiIl19LHsibiI6MywiY2VsbHMiOlsiQmFuYW5hcyIsIjE4IiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiQ2hlcnJpZXMiLCI0NSIsIiIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkRhdGVzIiwiMzgiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJGaWdzIiwiNiIsIiIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9zaGVldHMvcHJhY3RpY2UvaW5kZXgtbWF0Y2gi%2Cs_ZWqa1BBDxoOZK0St.png"
---

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

# **INDEX and MATCH practice in Google Sheets**

MATCH finds the position of a value and INDEX returns the value at a position. Both take the same arguments in Google Sheets as in Excel, so INDEX MATCH looks up in any direction there too.

[**Start the first exercise**](https://practiceexcelonline.com/sheets/practice/index-match/match-function)

INDEX(MATCH(

1. [**1****Find a position with MATCH**In E2, use MATCH to find the position of the product in D2 within A2:A7. Add 0 as the last argument for an exact match.](https://practiceexcelonline.com/sheets/practice/index-match/match-function)
2. [**2****Look up a price with INDEX and MATCH****Premium**In F2, return the Price of the product in E2. Use MATCH to find its row in A2:A7 and INDEX to pick that row from C2:C7.](https://practiceexcelonline.com/sheets/practice/index-match/index-match)
3. [**3****Look to the left with INDEX and MATCH****Premium**The IDs are in column C, to the right of the names. In F2, return the Name for the ID in E2 with INDEX and MATCH.](https://practiceexcelonline.com/sheets/practice/index-match/index-match-left-lookup)
4. [**4****A two-way lookup with INDEX and two MATCHes****Premium**In H3, find the sales for the product in H1 and the region in H2. INDEX the numbers B2:E5 with one MATCH for the row and one for the column: INDEX(B2:E5,MATCH(H1,A2:A5,0),MATCH(H2,B1:E1,0)).](https://practiceexcelonline.com/sheets/practice/index-match/index-match-match-two-way)

## **Functions in this topic**

- [**INDEX**](https://practiceexcelonline.com/sheets/functions/index)
- [**MATCH**](https://practiceexcelonline.com/sheets/functions/match)

## **Questions**

<details>

<summary>

### Should I use INDEX MATCH or XLOOKUP in Google Sheets?

</summary>

Both work. XLOOKUP is shorter to write; INDEX MATCH also works in older versions of Excel, so it is worth knowing if you share files.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/sheets/practice/index-match#webpage","description":"Practice INDEX and MATCH in Google Sheets, including lookups to the left, in exercises that are checked as you type.","name":"INDEX MATCH in Google Sheets: practice exercises","url":"https://practiceexcelonline.com/sheets/practice/index-match","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/sheets/practice/index-match#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/sheets/practice/index-match#/schema/question/1"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/sheets/practice/index-match"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/sheets/practice/index-match#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Google Sheets practice exercises","item":"https://practiceexcelonline.com/sheets","position":2},{"@type":"ListItem","name":"INDEX MATCH in Google Sheets: practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/sheets/practice/index-match#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Should I use INDEX MATCH or XLOOKUP in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"Both work. XLOOKUP is shorter to write; INDEX MATCH also works in older versions of Excel, so it is worth knowing if you share files."}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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