---
title: "VLOOKUP in Google Sheets: practice exercises | ExcelSavvy"
description: "Practice VLOOKUP in Google Sheets: exact and approximate match and the usual #N/A errors, in exercises that are checked as you type."
canonical_url: "https://excelsavvy.com/sheets/practice/vlookup"
meta:
  "og:description": "Practice VLOOKUP in Google Sheets: exact and approximate match and the usual #N/A errors, in exercises that are checked as you type."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBwcmFjdGljZSBleGVyY2lzZXM%2Cdescription_~UHJhY3RpY2UgVkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBleGFjdCBhbmQgYXBwcm94aW1hdGUgbWF0Y2ggYW5kIHRoZSB1c3VhbCAjTi9BIGVycm9ycywgaW4gZXhlcmNpc2VzIHRoYXQgYXJlIGNoZWNrZWQgYXMgeW91IHR5cGUu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRyJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDb2RlIiwiUHJvZHVjdCIsIlByaWNlIiwiUHJpY2UiXX0seyJuIjoyLCJjZWxscyI6WyJBMTAiLCJQZW4iLCIxMiIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkIyMCIsIk5vdGVib29rIiwiMzUiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJDMzAiLCJTdGFwbGVyIiwiODkiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJENDAiLCJGb2xkZXIiLCIyNCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9zaGVldHMvcHJhY3RpY2Uvdmxvb2t1cCI%2Cs_-wW9Ii0tsrfd6Aei.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "VLOOKUP in Google Sheets: practice exercises | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBwcmFjdGljZSBleGVyY2lzZXM%2Cdescription_~UHJhY3RpY2UgVkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBleGFjdCBhbmQgYXBwcm94aW1hdGUgbWF0Y2ggYW5kIHRoZSB1c3VhbCAjTi9BIGVycm9ycywgaW4gZXhlcmNpc2VzIHRoYXQgYXJlIGNoZWNrZWQgYXMgeW91IHR5cGUu%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRyJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDb2RlIiwiUHJvZHVjdCIsIlByaWNlIiwiUHJpY2UiXX0seyJuIjoyLCJjZWxscyI6WyJBMTAiLCJQZW4iLCIxMiIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkIyMCIsIk5vdGVib29rIiwiMzUiLCIiXX0seyJuIjo0LCJjZWxscyI6WyJDMzAiLCJTdGFwbGVyIiwiODkiLCIiXX0seyJuIjo1LCJjZWxscyI6WyJENDAiLCJGb2xkZXIiLCIyNCIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9zaGVldHMvcHJhY3RpY2Uvdmxvb2t1cCI%2Cs_-wW9Ii0tsrfd6Aei.png"
---

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

# **VLOOKUP practice in Google Sheets**

VLOOKUP looks up a value in the first column of a table and returns a value from another column. Google Sheets calls the last argument is\_sorted, but it works as in Excel: FALSE for an exact match, and TRUE or left out for the nearest smaller value in a sorted column.

[**Start the first exercise**](https://excelsavvy.com/sheets/practice/vlookup/vlookup-exact-match)

VLOOKUP(

## **How VLOOKUP works**

VLOOKUP finds a value in the first column of a table and returns the value from another column in the same row. It takes four arguments: what to look for, the table, which column to return (counting from the table's first column), and FALSE for an exact match.

`**=VLOOKUP(A2,$E$2:$G$50,3,FALSE)**` looks up the ID in A2 in the first column of E2:G50 and returns the third column. The dollar signs keep the table in place when you copy the formula down.

Most VLOOKUP mistakes are one of three things: leaving out FALSE, so Excel returns the nearest match instead of an exact one; a lookup value that is not in the first column of the table; and IDs stored as text in one place and as numbers in the other. The exercises below cover a price lookup, a number key, approximate match for bands, filling prices into an order list with a locked table, and a lookup that fails on a stray space.

1. [**1****Look up a price with VLOOKUP**In G2, use VLOOKUP to find the Price of the code in F2. Ask for an exact match.](https://excelsavvy.com/sheets/practice/vlookup/vlookup-exact-match)
2. [**2****VLOOKUP a number key****Premium**In G2, use VLOOKUP to return the Salary of the employee whose ID is in F2.](https://excelsavvy.com/sheets/practice/vlookup/vlookup-number-id)
3. [**3****VLOOKUP with an approximate match****Premium**In E2, find the commission rate for the sales in D2. The table lists where each band starts, so use VLOOKUP with TRUE for an approximate match.](https://excelsavvy.com/sheets/practice/vlookup/vlookup-approximate-match)
4. [**4****Bring prices into an order list****Premium**In C2, look up the price of the code in B2 in the price table E2:F5. Lock the table with $ so the formula can be filled down the order list: VLOOKUP(B2,$E$2:$F$5,2,FALSE).](https://excelsavvy.com/sheets/practice/vlookup/vlookup-fill-down-locked-table)
5. [**5****Fix a VLOOKUP that fails on a space****Premium**The code in F2 was pasted from an email and ends with a space, so a plain VLOOKUP returns #N/A. In G2, look up the price with TRIM(F2) as the lookup value.](https://excelsavvy.com/sheets/practice/vlookup/vlookup-trim-spaces)

## **Functions in this topic**

- [**VLOOKUP**](https://excelsavvy.com/sheets/functions/vlookup)

## **Questions**

<details>

<summary>

### Why does VLOOKUP return #N/A in Google Sheets?

</summary>

The value is not in the first column of the range. Check for extra spaces, numbers stored as text and a missing FALSE at the end, just as in Excel.

</details>

<details>

<summary>

### Can VLOOKUP look to the left in Google Sheets?

</summary>

No. VLOOKUP only returns columns to the right of the lookup column, as in Excel. Use XLOOKUP or INDEX and MATCH instead. XLOOKUP works in Google Sheets with the same arguments as in Excel, and its return range can sit on either side of the lookup range.

</details>

```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/practice/vlookup#webpage","description":"Practice VLOOKUP in Google Sheets: exact and approximate match and the usual #N/A errors, in exercises that are checked as you type.","name":"VLOOKUP in Google Sheets: practice exercises","url":"https://excelsavvy.com/sheets/practice/vlookup","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/sheets/practice/vlookup#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/sheets/practice/vlookup#/schema/question/1"},{"@id":"https://excelsavvy.com/sheets/practice/vlookup#/schema/question/2"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/sheets/practice/vlookup"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/sheets/practice/vlookup#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":"VLOOKUP in Google Sheets: practice exercises","position":3}]},{"@id":"https://excelsavvy.com/sheets/practice/vlookup#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Why does VLOOKUP return #N/A in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"The value is not in the first column of the range. Check for extra spaces, numbers stored as text and a missing FALSE at the end, just as in Excel."}},{"@id":"https://excelsavvy.com/sheets/practice/vlookup#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Can VLOOKUP look to the left in Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"No. VLOOKUP only returns columns to the right of the lookup column, as in Excel. Use XLOOKUP or INDEX and MATCH instead. XLOOKUP works in Google Sheets with the same arguments as in Excel, and its return range can sit on either side of the lookup range."}},{"@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"}]}
```

## Sitemap

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