MS Excel – join two tables

Here is a standard issue – you have several Excel tables that stores different aspects about the same thing. And you need to jump between those spreadsheets back and forward. A lot of fun, but not very effective 🙂 .

In SQL you can do joins. Excel is powerful enough to do the same and with less lines. MATCH and INDEX functions will help us. MATCH finds the place of occurrence and INDEX uses it to take the value.

Continue reading