---
title: "VLOOKUP in Google Sheets: syntax and examples | ExcelSavvy"
description: "Looks for a value in the first column of a table and returns the value from another column in the same row. With examples and exercises in Google Sheets."
canonical_url: "https://excelsavvy.com/sheets/functions/vlookup"
meta:
  "og:description": "Looks for a value in the first column of a table and returns the value from another column in the same row. With examples and exercises in Google Sheets."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_Looks%2Bfor%2Ba%2Bvalue%2Bin%2Bthe%2Bfirst%2Bcolumn%2Bof%2Ba%2Btable%2Band%2Breturns%2Bthe%2Bvalue%2Bfrom%2Banother%2Bcolumn%2Bin%2Bthe%2Bsame%2Brow.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VkxPT0tVUChsb29rdXBfdmFsdWUsIHRhYmxlX2FycmF5LCBjb2xfaW5kZXhfbnVtLCBbcmFuZ2VfbG9va3VwXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3Zsb29rdXAi%2Cs_SkG1BWT1XMngIH_w.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "VLOOKUP in Google Sheets: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_Looks%2Bfor%2Ba%2Bvalue%2Bin%2Bthe%2Bfirst%2Bcolumn%2Bof%2Ba%2Btable%2Band%2Breturns%2Bthe%2Bvalue%2Bfrom%2Banother%2Bcolumn%2Bin%2Bthe%2Bsame%2Brow.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VkxPT0tVUChsb29rdXBfdmFsdWUsIHRhYmxlX2FycmF5LCBjb2xfaW5kZXhfbnVtLCBbcmFuZ2VfbG9va3VwXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3Zsb29rdXAi%2Cs_SkG1BWT1XMngIH_w.png"
---

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

# **VLOOKUP in Google Sheets**

Looks for a value in the first column of a table and returns the value from another column in the same row.

=

VLOOKUP(

## **In Google Sheets**

In Google Sheets the arguments are called search\_key, range, index and is\_sorted, but they work as here. is\_sorted defaults to TRUE, so write FALSE for an exact match, as in Excel.

## **How to use VLOOKUP**

VLOOKUP works like a phone book: you know the name, it finds the row and reads off the number next to it. In a spreadsheet it searches down the first column of a table for your value, then returns something from the same row, from the column you choose.

Reach for it when two lists share a key. A sales list has product codes and you want the price from the price list. A staff list has employee numbers and you want the department. An invoice has a customer ID and you want the name. Write the formula once, fill it down, and every row gets its own answer.

The four arguments say what to find, where to look, which column to return and how exactly to match. The table must start with the column that holds the key, and the column number counts from the left edge of the table, not from column A. For an exact match, end with FALSE, as in `**=VLOOKUP(A2,Prices!$A$2:$C$100,3,FALSE)**`. VLOOKUP only returns columns to the right of the key. When you need to look left, or want a formula that survives inserted columns, use XLOOKUP or INDEX with MATCH. Wrap it in IFERROR when you would rather see a blank or a message than #N/A.

## **Syntax**

```
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
```

<dl><dt>**lookup_value **</dt>
<dd>The value to find in the first column.</dd>
<dt>**table_array **</dt>
<dd>The table, starting with the column to search.</dd>
<dt>**col_index_num **</dt>
<dd>Which column of the table to return, counting from 1.</dd>
<dt>**range_lookup **(optional)</dt>
<dd>FALSE for an exact match. TRUE or left out finds the closest smaller value in a sorted column.</dd></dl>

## **Examples**

D1`=VLOOKUP(<sup>1</sup>"Pear",<sup>2</sup>A2:B4,<sup>3</sup>2,<sup>4</sup>FALSE)`

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

**In plain words:** Find <sup>1</sup>Pear in the first column of <sup>2</sup>A2:B4 and return the value <sup>3</sup>in the table's second column, <sup>4</sup>only on an exact match.

D1=VLOOKUP("Kiwi",A2:B4,2,FALSE)

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

E2`=VLOOKUP(<sup>1</sup>TRIM(D2),<sup>2</sup>A2:B4,<sup>3</sup>2,<sup>4</sup>FALSE)`

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

**In plain words:** Find <sup>1</sup>the fruit in D2 without extra spaces in the first column of <sup>2</sup>A2:B4 and return the value <sup>3</sup>in the second column, <sup>4</sup>only on an exact match.

## **Common VLOOKUP mistakes**

- VLOOKUP returns #N/A even though the value is in the list

  The two values look the same but are not. Usually there is a stray space after the text, as in `**"Pear "**`, or one side is a number and the other is text. Clean the lookup value with `**=VLOOKUP(TRIM(D2),A2:B4,2,FALSE)**`. If a number is stored as text, `**VALUE(D2)**` turns it into a real number.
- VLOOKUP returns a wrong price and shows no error

  The fourth argument is missing, so VLOOKUP does an approximate match and takes the nearest smaller value, which only makes sense in a sorted list. Add FALSE as the fourth argument: `**=VLOOKUP(A2,$F$2:$G$20,2,FALSE)**`.
- The formula works in the first row but gives #N/A further down

  When you fill the formula down, the table reference moves down with it, and sooner or later the key falls outside it. Lock the table with dollar signs, as in `**$F$2:$G$20**`. Select the range in the formula and press F4 to add them.
- I need a column that sits to the left of the key

  VLOOKUP can only return columns to the right of the one it searches. Use `**=INDEX(A2:A20,MATCH(E2,B2:B20,0))**` or `**=XLOOKUP(E2,B2:B20,A2:A20)**` instead, or move the key column to the front of the table.

## **Practice VLOOKUP**

- [**1****Look up a price with VLOOKUP**→](https://excelsavvy.com/sheets/practice/vlookup/vlookup-exact-match)
- [**2****VLOOKUP a number key**→](https://excelsavvy.com/sheets/practice/vlookup/vlookup-number-id)
- [**3****VLOOKUP with an approximate match**→](https://excelsavvy.com/sheets/practice/vlookup/vlookup-approximate-match)
- [**4****Bring prices into an order list**→](https://excelsavvy.com/sheets/practice/vlookup/vlookup-fill-down-locked-table)
- [**5****Fix a VLOOKUP that fails on a space**→](https://excelsavvy.com/sheets/practice/vlookup/vlookup-trim-spaces)

## **Related functions**

- [**XLOOKUP**](https://excelsavvy.com/sheets/functions/xlookup)
- [**INDEX**](https://excelsavvy.com/sheets/functions/index)
- [**MATCH**](https://excelsavvy.com/sheets/functions/match)
- [**HLOOKUP**](https://excelsavvy.com/functions/hlookup)

```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/vlookup#webpage","@type":"WebPage","dateModified":"2026-11-16","description":"Looks for a value in the first column of a table and returns the value from another column in the same row. With examples and exercises in Google Sheets.","name":"VLOOKUP in Google Sheets: syntax and examples","url":"https://excelsavvy.com/sheets/functions/vlookup","breadcrumb":{"@id":"https://excelsavvy.com/sheets/functions/vlookup#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/sheets/functions/vlookup"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/sheets/functions/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: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/sheets/functions/vlookup#article","dateModified":"2026-11-16","description":"Looks for a value in the first column of a table and returns the value from another column in the same row. With examples and exercises in Google Sheets.","headline":"VLOOKUP in Google Sheets: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_Looks%2Bfor%2Ba%2Bvalue%2Bin%2Bthe%2Bfirst%2Bcolumn%2Bof%2Ba%2Btable%2Band%2Breturns%2Bthe%2Bvalue%2Bfrom%2Banother%2Bcolumn%2Bin%2Bthe%2Bsame%2Brow.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VkxPT0tVUChsb29rdXBfdmFsdWUsIHRhYmxlX2FycmF5LCBjb2xfaW5kZXhfbnVtLCBbcmFuZ2VfbG9va3VwXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3Zsb29rdXAi%2Cs_SkG1BWT1XMngIH_w.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/vlookup#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/sheets/functions/vlookup#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_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_Looks%2Bfor%2Ba%2Bvalue%2Bin%2Bthe%2Bfirst%2Bcolumn%2Bof%2Ba%2Btable%2Band%2Breturns%2Bthe%2Bvalue%2Bfrom%2Banother%2Bcolumn%2Bin%2Bthe%2Bsame%2Brow.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VkxPT0tVUChsb29rdXBfdmFsdWUsIHRhYmxlX2FycmF5LCBjb2xfaW5kZXhfbnVtLCBbcmFuZ2VfbG9va3VwXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3Zsb29rdXAi%2Cs_SkG1BWT1XMngIH_w.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~VkxPT0tVUCBpbiBHb29nbGUgU2hlZXRzOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_Looks%2Bfor%2Ba%2Bvalue%2Bin%2Bthe%2Bfirst%2Bcolumn%2Bof%2Ba%2Btable%2Band%2Breturns%2Bthe%2Bvalue%2Bfrom%2Banother%2Bcolumn%2Bin%2Bthe%2Bsame%2Brow.%2BWith%2Bexamples%2Band%2Bexercises%2Bin%2BGoogle%2BSheets.%2Ceyebrow_Google%2BSheets%2Bpractice%2Bexercises%2Csite_practiceexcel%2Ccode_~VkxPT0tVUChsb29rdXBfdmFsdWUsIHRhYmxlX2FycmF5LCBjb2xfaW5kZXhfbnVtLCBbcmFuZ2VfbG9va3VwXSk%2Cp_Ii9zaGVldHMvZnVuY3Rpb25zL3Zsb29rdXAi%2Cs_SkG1BWT1XMngIH_w.png"}]}
```

## Sitemap

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