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.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.