In this tutorial, we will show you exactly how to use VLOOKUP between two sheets in just a few simple steps using an example. Simply follow the steps below.
Follow the steps below to learn how to use the VLOOKUP function between two sheets.
Make sure both sheets with your data are in the same workbook. One sheet will have the data you want to look up, and the other will have the reference data.
In the sheet where you want the result, find the cell with the value you’re looking up. In this case, it’s the city and we’re looking up the corresponding state.
In the new column where you want the data to show, click a cell and type =VLOOKUP(. Then, select the lookup value you just identified, in this case, New York.
Switch to the other sheet with the reference data. Select the range of data, without headers. Lock this range by pressing F4.
After the data range, type a comma and then the column number where the data you want is located. In this example, type 3 as the data we need is in the third column.
Add a comma, then type FALSE to make sure you get an exact match.
Finish the formula with a close parenthesis ")" and press Enter. You should see the result.
Drag the formula down to apply it to the rest of the column.
We hope that you now have a better understanding of how to use VLOOKUP to find matches in two sheets. If you enjoyed this article, you might also like our article on how to insert a table from Google Sheets into Google Docs.
