Better Sheets

How to do vlookup in Google Sheets from a different tab

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 do vlookup in google sheets from a different tab.

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 do I reference a different spreadsheet in Apps Script?

I'll show you how to get text from one spreadsheet file to another with ...

Intermediate

IMPORTRANGE()

How To Create An AutoFill in Google Sheets

Autofill inside of google sheets is possible with Dropdowns.

Beginner

INDEX() MATCH() VLOOKUP()

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open....

Intermediate

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far ...

Intermediate

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, ge...

Intermediate

Sync Two Tabs Without ImportRange()

Get this epic script that automatically edits two tabs and keeps them in...

Advanced

Unlock these tutorials

Related blog posts

Written guides that go deeper on this question.

Browse the blog

How to reference a different Google Spreadsheet in Apps Script?

Transferring Data Between Cells in Different Spreadsheets

Make It Easier For Others To Use Your Google Sheets

In this tutorial, we're going to orient users better in Google Sheets. We want to help not just ourselves but also anyone who’s going to use a spreadsheet that we have created.

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

Better Sheets on YouTube

Watch matching videos from youtube.com/bettersheets.

No exact channel match cached for “How to do vlookup in Google Sheets from a different tab” 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 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 →

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 →

How to do vlookup in Google Sheets from a different 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 do vlookup in google sheets from a different sheet.

Get the answer →

How to use vlookup in Google Sheets from a different 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 in google sheets from a different sheet.

Get the answer →

Can i use vlookup in different 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 in different sheets.

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