Table of Contents
VLOOKUP is a function in Google Sheets that allows users to search for a specific value in a table and return a corresponding value from a different column. This function can also be used across different workbooks, allowing users to access data from multiple sources in one sheet. To use VLOOKUP from another workbook, the user must first open both workbooks and ensure that the value being searched for is in the first column of the table. The formula then consists of the name of the workbook, followed by an exclamation mark, and the range of cells containing the data. This allows for efficient data management and analysis, as users can easily access and reference data from multiple workbooks within one sheet.
Google Sheets: 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:
The values in the Assists column of the second workbook have now all been pulled into the first workbook.
Cite this article
stats writer (2024). How can I use VLOOKUP from another workbook in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-from-another-workbook-in-google-sheets/
stats writer. "How can I use VLOOKUP from another workbook in Google Sheets?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-from-another-workbook-in-google-sheets/.
stats writer. "How can I use VLOOKUP from another workbook in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-from-another-workbook-in-google-sheets/.
stats writer (2024) 'How can I use VLOOKUP from another workbook in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-vlookup-from-another-workbook-in-google-sheets/.
[1] stats writer, "How can I use VLOOKUP from another workbook in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use VLOOKUP from another workbook in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.