Google Sheets: How to Use VLOOKUP From Another Workbook


You can use the following basic syntax to perform a VLOOKUP from another workbook in Google Sheets:

=VLOOKUP(A2, IMPORTRANGE("1AdlE5drC", "'sheet1'!$A$1:$B$11"), 2, 0)

This particular formula will look up the value in cell A2 of the current workbook in the range A1:B11 of a second workbook that has a spreadsheet key of 1AdlE5drC and return the corresponding value in the second column.

The following step-by-step example shows how to use this formula in practice.

Step 1: Enter Data into Both Workbooks

Suppose our current workbook contains the following data:

And suppose we have another workbook with the following data:

Step 2: Perform VLOOKUP Between Workbooks

Now suppose we would like to use a VLOOKUP in the first workbook to look up the team names in the second workbook and return the corresponding value in the Assists column.

Before we perform this VLOOKUP, we must find the spreadsheet key in the URL of the second workbook:

We can then type the following formula into cell C2 of the first workbook:

=VLOOKUP(A2, IMPORTRANGE("1_W-W0fbIYl74Kp2y5ruaGyFjWOskrcPBdQ6Vk_t_dRQ", "'sheet1'!$A$1:$B$11"), 2, 0)

Once we press Enter, the value in the Assists column from the second workbook that corresponds to the “Mavs” team will be shown:

We can then drag and fill this formula down to each remaining cell in column C to find the Assists values for each team:

The values in the Assists column of the second workbook have now all been pulled into the first workbook.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: Use IMPORTRANGE with Multiple Sheets
Google Sheets: How to Use IMPORTRANGE with Conditions
Google Sheets: Use VLOOKUP with Multiple Criteria

Leave a Reply

Your email address will not be published.