In this tutorial, we will learn to use VLOOKUP to look up a value in another sheet of the same workbook and a sheet of another workbook. So, let’s get started.
VLOOKUP to in Another Sheet of the Same Workbook
- First, enter VLOOKUP in a cell, and in the first argument, refer to the values you are lookup for.
- Now, enter a comma to go to the next argument. And then click on the “Sheet2” tab, then select the range A1:B10.
- From here, enter 2 in the index argument, as we need to get the value from the second column of the range we have specified.
- In the end, enter 0 in the is_sorted argument, then press enter to get the result.
Note: If you don’t want to select the range in another sheet with your mouse, you can manually type its name in the formula along with the sheet’s name, exclamation mark, and then the range address.
VLOOKUP to in Another Sheet of a Different Workbook (VLOOKUP and IMPORTRANGE)
In this example, we have two Google Sheets. One is where you want to apply VLOOKUP, and one is where the lookup data is.
- The first thing you need to do is get the share link of the Google Sheet here; you have the data. So, for this, click on the “Share” button.
- After that, select “Anyone with the link” from the general access, and the then click on the “Copy Link” button.
- Next, go back to the main sheet where you want to apply the VLOOKUP and then enter the VLOOKUP in the way you want to apply.
- Refer to the cell where you have the lookup value and, in the range argument, enter the IMPORTRANGE function.
- In the first argument, enter the link you have copied from another workbook.
- In the second argument, enter the sheet name and the range you want to specify to the range argument of the VLOOKUP.
- Now, specify the 2 in the index argument of the VLOOKUP and 0 in the is_sorted argument.
- In the end, hit enter to get the result.
Link-1 and Link-2) to try it yourself.