Excel - joining data

How to join data in Excel (when you don't have Access)

Using Microsoft Access is a quick way to join data, but many people don't have Access. And it's not even offered for Apple users. So here's the workaround using the VLookup function in Excel.


Let's assume you have a list of towns (Column A) and states (Column B), but the states are listed by the two-letter postal abbreviations. You want to change the abbreviations to the full state names without having to search and replace 50 times for 50 different states.

Step 1

Step 2

Step 3

Type in this formula in cell C2, next to the first set of values

How to use vLookup in Excel

Step 4

Explaining the formula

How to use vLookup in Excel

See more Excel tips