Saturday, July 28, 2012

How to Do a VLOOKUP With Two Spreadsheets in Excel


1. Select the cell in which you want the returned value.
2. Click on the formula bar, the long empty box at the top of the screen.
3. Type =VLOOKUP(“text you want to match”,Be sure to include the double quotes.
4. Click the tab of the other spreadsheet, the one holding the searchable table.
5. Highlight the table.
6. Click back to the original spreadsheet. Now the location will be in the VLOOKUP function.
7. 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.
8. Type a closing parenthesis and press “Enter.”

Blogger news