You can use VLOOKUP to get data from another sheet in the same workbook in Google Sheets. You can see in the example below that we have used VLOOKUP to get the quantity from another sheet by looking up the Product ID. And in this tutorial, we learn to write this formula.
You can use the below steps to write this formula:
- First, you need to enter the VLOOKUP in a cell and refer to the cell where you have the lookup value.
- Now, click on the “Sheet2” tab to open it.
- Select the data range from “Sheet2” to specify it in the function.
- After that, enter 2 in the index and 0 in the [is_sorted] arguments.
- In the end, hit enter to get the result.
=VLOOKUP(A2,'Sheet 3'!A1:B8,2,0)Important Points
If you change the name of the data sheet from “Sheet2” to anything (Example: Sheet3), Google Sheets is smart enough to change the name in the formula as well.
But if you delete the sheet from the workbook, you will get the #REF! Error in the result. But there’s a good thing; you can get your deleted sheet back using the undo keyboard shortcut Ctrl + Z.
=VLOOKUP(A2,MyRange,2,0)
And if you create a named range for the data you have in another sheet, you can enter it in the range argument of the VLOOKUP instead of navigating to the sheet and selecting the range from there.
