In Microsoft Excel, you can create relationships between two tables based on the matching data within the table, even when the tables are from different sources.

Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.

Once you have identified the common fields, you can establish relationships between tables. To create a relationship, simply drag the common field from one table to another in Diagram View.