Spreadsheet Tip: Advanced Sorting with VLOOKUP

In a spreadsheet, say you want to add a new column of unsorted data to an existing table of custom-sorted data. You’ve already sorted the original table by hand, but you want the software to do the heavy lifting now.

You will need to import the new column with one column that’s in your original table, to serve as a key between the two.

To automatically sort the new column, use the VLOOKUP function (short for “vertical lookup”), available in many spreadsheet programs. This lets you look up the column that’s in both tables, find the right value from the new column, and add that to the original table in the right place.

1. Copy your new columns into the spreadsheet.
2. Add a blank column to your original table.
3. In the blank column, add a VLOOKUP function for each row.

Excel: http://www.techonthenet.com/excel/formulas/vlookup.php

Google spreadsheets: https://support.google.com/docs/answer/3093318

vlookup5

Image Source

By Sharon Campbell

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: