4 ms·
Excel allows creating primary/foreign key relationships between tables using the Data tab, but you can only use these relationships to produce pivot tables, not
by jsmith99 7y ago
Excel allows creating primary/foreign key relationships between tables using the Data tab, but you can only use these relationships to produce pivot tables, not in normal formulas.
- collyw 7y agoBut buy the time you get to understand how to do things like this in Excel, why not just use the proper tool for the job - a database. (I haven't used it in many years but MS Access was a pretty efficient way to get an application together).
- froindt 7y agoAdmittedly not great, but you can complete that join, output it as a table, and then apply formulas as desired if you use Power Query. Power Query solves many cases where a macro was previously required, but relatively few people are aware of it.