How to Connect Tables in Excel

How to build Relationships between Excel Tables, in other words How to Connect Excel Tables is explained in this video.

Intro (0:00)
Example of complex VLOOKUP formula that slows down the workbooks (0:31)
Connect 2 Excel Tables (4:55)
Create Pivot Table after connecting two Tables (7:22)
Connect 3 or more Tables (8:42)
Create Pivot Table after connecting 3Tables (10:20)

Subscribe to the channel for more

Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!

#ExcelTable #ConnectTable

[ret]

I was already familiar with interlinking relationships in Access database, but did not realize the same could be done inside Excel's data model tool. Very helpful. Thank you for showing first example, then the more elegant solution.

[rosemaryhodges]

Thank you for sharing Ajay. It was a great help to refesh rusty skills.

[roddo]

Excellent simple to understand example. Thankyou!

[ashrafjamil]

Many thanks to you respected lecturer for this valuable information, Respectfully yours and Much appreciated,

[pjsmith]

Very helpful, thanks Ajay. You have a new subscriber!

[adityapuro]

Hey, Ajay, your content was helpful. Keep Growing!!

[AriWahyudi]

Thank you for this very valuable lecture Sir.

[sallum]

THank you for a very educative one query.... do the tables being linked have to be in same worksheet or even workbook ??

[fliptop]

Thanks! This should help me with managing my projects at work. I thought I needed to define a primary key to relate the tables, but I now see I don't.

[a.s.l]

do you have an excel file for this example?

[codelover]

How do i find relationship feature in ms 2007