How to Do a VLOOKUP With Two Spreadsheets in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Use Excel's VLOOKUP function to quickly find any value in a worksheet.
Image Credit: Szepy/iStock/Getty Images

The VLOOKUP function in Excel looks for a certain entry in the first column of a vertically oriented table. After it finds the row with the first match, it finds the column you specify in the function. The function then returns the cell contents of that row and column from the searched table. If you need to perform such a search through a separate spreadsheet in the same workbook, you can adapt the function to do so.

Advertisement

Step 1

Select the cell in which you want the returned value. Click on the formula bar, the long empty box at the top of the screen.

Video of the Day

Step 2

Type the following into the formula bar, taking care to include the quotation marks around the text you want to match: =VLOOKUP("put text here",

Advertisement

Step 3

Click the tab of the other worksheet containing the searchable table, then highlight this table.

Step 4

Click back to the original spreadsheet where you began typing the VLOOKUP function. Note that the table location has been inserted in the VLOOKUP function.

Advertisement

Advertisement

Step 5

Click the formula bar again. Add a comma after the table location and type in which column you want the value returned from. For example, if you want to return two columns to the right of the search column, type "3."

Step 6

Type a closing parenthesis and press "Enter."

Video of the Day

Advertisement

Advertisement

references