Better Sheets

How to use vlookup in Google Sheets

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to use vlookup.

Steps

1
Click an empty cell and type =VLOOKUP(.
2
Fill arguments using the on-screen helper.
3
Press Enter and check a known expected result.
4
Widen ranges or add IFERROR once the logic is correct.

Related tutorials

These videos might help you go deeper on this topic.

Browse more tutorials

Use Index Match when you want Vlookup

If you find Vlookup a difficult formula to understand, this formula comb...

Intermediate

INDEX() MATCH() MAX() VLOOKUP()

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1) Do you know why this is s...

CONCAT() DATE() MONTH() VALUE()

Find Column with Header to Bullet Proof your Vlookup

Make your VLOOKUP formulas flexible and your data move-able with this tr...

Intermediate

HLOOKUP() MATCH() VLOOKUP()

Unlock these tutorials

Related blog posts

Written guides that go deeper on this question.

Browse the blog

How To Calculate ROAS in Google Sheets

Showing you two ways to use sheets to calculate Return on ad Spend. ROAS. One way with formulas and one way with Apps Script. Learn more at Better Sheets: https://Bettersheets.co

How to reference a different Google Spreadsheet in Apps Script?

Transferring Data Between Cells in Different Spreadsheets

How To Make That Viral Growing Plant Progress Chart

You might have seen a viral TikTok where there is a progress bar and a growing sort of garden of flowers or potted plant that's growing as you check off these task bars tasks. So I want to walk through what this formula, the combination is how it's really cool it

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

No exact channel match cached for “How to use vlookup in Google Sheets” yet. Search Better Sheets on YouTube.

Terms and formulas behind this

Want the full definition or how a formula works? Start here.

VLOOKUP

VLOOKUP searches the first column of a range for a key and returns a value from a specified column to the right. It i...

Google Sheets formulas

A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...

Google Sheets formula syntax

Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...

Formula errors in Google Sheets

Formula errors are typed messages in cells when something prevents a valid result. Each code points to a different fa...

IFERROR

IFERROR wraps another formula and returns value_if_error when the inner expression hits any error, including #N/A, #R...

IFERROR()

Google Sheets IFERROR() function guide

VLOOKUP()

Google Sheets VLOOKUP() function guide

Related questions

Can you vlookup from a vlookup

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to can you vlookup from a vlookup.

Get the answer →

Can you vlookup a vlookup

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to can you vlookup a vlookup.

Get the answer →

How to use vlookup on Google Sheets

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to use vlookup.

Get the answer →

How to use vlookup in google sheet

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to use vlookup.

Get the answer →

Can i use vlookup in Google Sheets

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to use vlookup.

Get the answer →

How use vlookup

VLOOKUP is a built-in Google Sheets function. Type =VLOOKUP( in a cell and follow the argument hints, or open the formula help from the function name. Start with a small example range, confirm the result, then expand. See the linked formula guide on this page for syntax and examples related to how use vlookup.

Get the answer →

Need more than a quick answer?

636+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.

Need one fix

Watch a free tutorial for the step-by-step version of any answer.

Browse more questions

Learning Sheets for real

Unlock the full library, generators, and templates with membership.

See membership