Excel

How to Do a VLOOKUP in Excel with Two Spreadsheets

How to Do a VLOOKUP in Excel with Two Spreadsheets

VLOOKUP is a function in Excel that allows you to look up values in one spreadsheet based on values in another spreadsheet. To do a VLOOKUP in Excel with two spreadsheets, you will need to follow these steps:

1. Open both of the spreadsheets that you want to use in the VLOOKUP.

2. In the spreadsheet that you want to use as the lookup table, type the values that you want to lookup in the first column.

3. In the spreadsheet that you want to use as the lookup table, type the column number of the column that contains the values you want to lookup in the second column.

4. In the spreadsheet that you want to use as the lookup table, type the keyword "VLOOKUP" in the cell where you want the lookup result to be displayed.

5. Click the "Enter" key on your keyboard.

6. Excel will return the value that is located in the same row in the lookup table as the value that is located in the first column.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.