Referencing Table Cells in Another Table

[mikeymikeymike]

Hi guys,

This problem is driving me crazy and also making my spreadsheet extremely slow. Assume I have a table called Table1 and another called Table2. Both have 3 rows and 3 columns including headers and the first column which is the name of people, for example. The names column in both table are the same. How do I EASILY reference different cells in Table2 from Table1 without using index, vlookup, etc.? The hard way that I've been filling my spreadsheet with, slowing it down is something like this:

(filling out a cell in Table2)
=index(Table1;[@row];match(columnx;Table1[#headers];0))

I can't for the life of me figure out if there's an easier way to do this. Am I overthinking too much? I don't have much experience, so I'm sure that plays a part.

Thanks

 

[mrshl9898]

You could add them to your data model in powerpivot and create a new pivot table to show what you need.

Look up how to enable it, then select a table and go PowerPivot > Add to data model.

Then go to PowerPivot > Manage, A window pops up then Home > Diagram view and drag the name field from one table to the other to create a relationship.

Then Insert > Pivot Table, click use external data source, choose connection, tables, and select the 2 tables.