Excel 2010, Two Tables, One to Many - Then Hope to Use Two Drop Down List from Results

Hey Everyone, I've spent all afternoon and last night searching and playing and I'm just not getting any closer on this one. So I've created this ever growing Workbook that I use to make Work Estimates off of. Now my office is using it, not just me so I have to make it as easy for everyone (plus it just makes since to have it evolve). On one Sheet 'Client DB', I have two tables. One is Client Company Info (Company Name, Address and such) and the other is Client Contact Info. Sample of Headers are below:

Table1:
Cname Caddress Ccity Cstate Czip .......


Table2:
Cname ContactFName ContactLName ContactTitle ContactPhone ........

On my first Sheet of my Workbook, I have where you put in all the basic info of the Work Estimate in all in one location. I currently have a Drop Down List for all the Clients, which will automatically fill in any cells relevant throughout the workbook, and just type in the Contact Name, Number and Email.

Now what I want to do is create a relationship between the two tables using 'Cname' (because I'll have more then one Contact under each Client many times), and when I do my second Drop down list on my first Sheet only those names are listed who are matching the Company who's being selected by the first Drop Down List.

In my head it seems to be such a simple thing to do, but I'm totally stuck on this. I don't know if it's the version of Excel I have to use, or I' overthinking it or what, but searching for it is a nightmare. When I try to backwards engineer it from videos or instructions online, it's like telling a caveman to tune a car. He might be able to do it, I just don't know HOW TO TELL HIM TO DO IT.

Any help in this would be great. Heck at this point, I'm not even sure anymore what the name of what i'm trying to do is anymore. LOL
Merry Christmas Everyone!

Shannon Rafferty
Big G Electric
Deadhorse, Alaska

Read about PowerQuery, PowerPivot and DataModel

maybe it will help also: Introduction to the Data Model and Relationships in Excel 2013

Originally Posted by sandy666

Read about PowerQuery, PowerPivot and DataModel

maybe it will help also: Introduction to the Data Model and Relationships in Excel 2013

Thanks,
I installed PowerPivot last night before I called it quits. I'll read up on it more and get familiar with it. Thanks for the link, I'll read it.

It's just sad that the company buys me a new laptop and mine that I bought myself 4 years ago is more powerful and running better software..... LOL I know that's not the only issue here, I haven't been a computer geek in about a decade and I feel it.

Originally Posted by psraff

It's just sad that the company buys me a new laptop and mine that I bought myself 4 years ago is more powerful and running better software..... LOL

Company economy