PracticeExcelSign in
Google Sheets practice exercises

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
  1. 1Find a position with MATCHIn 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.
  2. 2Look up a price with INDEX and MATCHPremiumIn 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.
  3. 3Look to the left with INDEX and MATCHPremiumThe 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.
  4. 4A two-way lookup with INDEX and two MATCHesPremiumIn 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)).

Functions in this topic

Questions

Should I use INDEX MATCH or XLOOKUP in Google Sheets?

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.