How to VLOOKUP From Another Workbook in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to VLOOKUP from another workbook Google Sheets.

How to use VLOOKUP With Another Workbook in Google Sheets

Here’s our step-by-step guide on how to use VLOOKUP with another workbook in Google Sheets.

Step 1

First, head to the source spreadsheet and click on the Share button.

Step 2

Click on Copy link to add the URL of the source spreadsheet into your clipboard.

Step 3

In the destination sheet, select an empty cell.

Step 4

Type the VLOOKUP function and specify the lookup value to use.

Step 5

Next, type the IMPORTRANGE function as the second argument of VLOOKUP. We will essentially use the results of our IMPORTRANGE function as our lookup table range.

We’ll use the URL in our clipboard as the first argument of the IMPORTRANGE function. Don’t forget to specify the sheet tab and range to import as the second argument.

Next, we’ll complete the rest of the necessary parameters for VLOOKUP.

Step 6

Hit the Enter key to evaluate the formula. Your formula should perform a VLOOKUP using the data imported from another workbook.

Summary

This guide should be everything you need to learn how to vlookup from another workbook in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.