How to Use VLOOKUP in Google Sheets: Step by Step (2026)

If you run a small business out of spreadsheets, you've probably got one tab with customers and another with orders, and a nagging feeling that someone should be matching them up by hand. VLOOKUP is the formula that does the matching for you. It looks scary for about five minutes and then it's the most useful thing in your toolkit.

I'll take it one argument at a time, using what Google's own function page says, so you know why each part is there and what to do when the answer comes back as an error.

What a VLOOKUP formula in Google Sheets looks like

Google gives the syntax as =VLOOKUP(search_key, range, index, [is_sorted]). Read it like a sentence: find this thing, in this block of cells, and bring back the answer from this column, using this type of match.

• search_key is the value you want to find. Google says it can be typed in or taken from a cell, and the cell route is the one you'll use most.
• range is the block of cells VLOOKUP searches. The thing you're looking for has to sit in the first column of that block.
• index is the column in the range that holds the answer, counting from 1 for the leftmost column. It must be a positive whole number.
• is_sorted is optional and sets the match type. FALSE asks for an exact match, TRUE asks for an approximate one.

Your first VLOOKUP in Google Sheets, step by step

Say column A of a tab called Customers holds customer names, column B holds email addresses and column C holds the town. On another tab you've typed a name and want the town beside it.

1. Click the cell where you want the answer to appear.
2. Type an equals sign and VLOOKUP, then an opening bracket.
3. Click the cell holding the name you want to find. That's your search_key.
4. Type a comma, then select the whole block on the Customers tab, from column A to column C.
5. Type a comma and the number 3, because the town is the third column of your block.
6. Type a comma and FALSE, then close the bracket and press Enter.

If the name exists in the first column, the town appears. If it doesn't, you'll get an error, which is covered further down.

Why Google says to spell out TRUE or FALSE in VLOOKUP

Here's the bit that catches people out. Google's page says TRUE is the default if you leave the last argument off, and it recommends always stating it explicitly. TRUE means approximate match, and for that to work the first column has to be sorted in ascending order or the result may be wrong.

For names, email addresses, product codes and order numbers, you want an exact match, so type FALSE. Approximate matching is for things like grading bands or tiers, where you want the nearest value below the one you searched for. Google also says that with approximate matching, a key smaller than the smallest value in the first column returns #N/A.

Setting	What Google's page says it does
FALSE	Exact match. Returns the row whose first-column value equals the key; no match gives #N/A. Wildcards only work here.
TRUE	Approximate match. Needs the first column sorted in ascending order or the result may be wrong.
Left out	Treated as TRUE, which is why Google recommends writing the argument every time.

Locking the VLOOKUP range so it copies down cleanly

You'll rarely write one VLOOKUP. You'll write one and drag it down a hundred rows. Google's advice is to use absolute references for the range, so the block doesn't slide down as you copy the formula.

Absolute references are written with a locking symbol before each column letter and row number. The quick way is to select the range inside the formula and press the F4 key, but keyboard shortcuts vary, so if nothing happens just type the symbols in yourself.

Fixing a VLOOKUP error in Google Sheets

An error isn't Sheets being awkward. Each one points at a specific problem, and Google lists what they mean:

• #N/A: no match was found. Check the spelling, and see the spaces point below. Google says you can wrap the whole formula in IFNA() if you'd rather show a friendly message or a blank than an error.
• #REF!: your index is bigger than the number of columns in the range. If you selected three columns, an index of 4 can't work.
• #VALUE!: the index is text, a misspelled column name or less than 1.
• #NAME?: a text search key is missing its opening or closing quotation mark.

When the formula runs but the answer is wrong, Google points at the usual suspects: an unsorted range combined with TRUE, stray spaces, or a search key that isn't in the first column of the range.

Why a VLOOKUP in Google Sheets won't match two things that look identical

Two culprits cause most of the confusion. First, Google says leading or trailing spaces make otherwise identical text fail to match, so trim them before you search. Second, numbers or dates stored as text can give unexpected results, so a customer number typed one way on one tab and another way on the second tab won't line up.

If you collect sign-ups through a form and then match them to a customer list, this is where it usually goes wrong, because people add a space at the end of their name without noticing. My comparison of form builders that can feed a spreadsheet is worth a look if you're choosing how to gather those answers in the first place.

What VLOOKUP in Google Sheets can't do

• It searches only the first column of your range and returns something to the right of it. If the answer sits to the left of the search column, you'll need to rearrange your data or use a different formula.
• Google says it returns only the first match when several rows match the key.
• There's no built-in way to use more than one criterion. Google's suggestion is a helper column that combines the fields, then search that column.

Google's page also points to XLOOKUP as a more flexible option for some queries. I'd learn VLOOKUP first because you'll meet it in every old template people send you, then explore the alternatives.

Wildcards in a VLOOKUP formula

When you only know part of a name, wildcards help. Google says they work only with an exact match: a question mark matches one character and an asterisk matches any sequence of characters. So typing a few letters, an asterisk, and nothing else in the search key lets you find a record from a partial name. Use it carefully, because you'll still only get the first match.

Where I'd use VLOOKUP in a small business

Once the pattern clicks, the uses stack up: pulling a customer's email address into a delivery list, matching product codes to names, checking which enquiries became orders, or filling a template with details from a master sheet. If you build documents from a spreadsheet, you might like my walkthrough of filling in a Google Docs template without the numbering chaos, which pairs nicely with a lookup tab.

Frequently asked questions

How do I use VLOOKUP in Google Sheets?

Type =VLOOKUP(search_key, range, index, FALSE). The search key is what you're looking for, the range is the block of cells whose first column contains it, the index is which column of the block to return, and FALSE asks for an exact match.

What does the number in a VLOOKUP formula mean?

That's the index. Google's help says it counts columns within your range, starting at 1 for the leftmost column, and it must be a positive whole number.

Why does my VLOOKUP return #N/A?

Google says #N/A means no match was found. Check spelling, trim leading or trailing spaces, make sure the search key is in the first column of the range, and confirm numbers aren't stored as text. IFNA() can replace the error with a message.

Should I use TRUE or FALSE in VLOOKUP?

Use FALSE when you need an exact match, which is most business lookups. TRUE gives an approximate match and needs the first column sorted in ascending order. Google recommends stating it every time.

Can VLOOKUP return more than one match?

No. Google's page says it returns only the first match. If you need to match on several things, add a helper column that combines the fields and search that instead.