Better Sheets

Can you do 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 can you do 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

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Use Index Match when you want Vlookup

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

Intermediate

INDEX() MATCH() MAX() 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()

World Peace in Google Sheets

Combining GoogleTranslate() and DetectLanguage() to figure out what a la...

Beginner

DETECTLANGUAGE() GOOGLETRANSLATE() VLOOKUP()

Most Common Errors and How To Handle Them in Google Sheets

Today we're gonna talk about errors in Google Sheets and how you can fix...

Beginner

CONCATENATE() VLOOKUP()

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's ...

Beginner

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 Say "I Do Google Sheets"

We do spreadsheets. That's what we do. We use Google Sheets for everything. So how on earth are we to get across all of the nuance and power that we hold at our finger tips?

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.

VLOOKUP not working #googlesheets

VLOOKUP not working #googlesheets

Watch on YouTube →

VLOOKUP NOT WORKING, Getting #N A

VLOOKUP NOT WORKING, Getting #N A

Watch 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 →

What does the vlookup function do

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 the vlookup function do.

Get the answer →

What does vlookup function do

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 vlookup function do.

Get the answer →

What is the vlookup function 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 the vlookup function.

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