Three tables, need to use two to populate data in third
Hi there -
The attached file is mostly self explanatory, but I need help answering the question "Does the driver speak language of country s/he drove in?" by using a table that shows the drivers and where they drove, then another table that shows drivers and the language(s) each speaks.
Thank you in advance for any help you can offer! :)
Drivers.xlsx
The attached file is mostly self explanatory, but I need help answering the question "Does the driver speak language of country s/he drove in?" by using a table that shows the drivers and where they drove, then another table that shows drivers and the language(s) each speaks.
Thank you in advance for any help you can offer! :)
Drivers.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Zack the firefighter paramedic dude!
Who needs Access when Excel can do anything Access can do and more? You don't like my array math? ;-)
Thank you again for the ride and lunch! Very much appreciated! Did you get to the car wash yet?
Smitty came by the other day with some wild stories about income sources and corporate greed. He also shared some of his recently harvested fruits and veggies.
Who needs Access when Excel can do anything Access can do and more? You don't like my array math? ;-)
Thank you again for the ride and lunch! Very much appreciated! Did you get to the car wash yet?
Smitty came by the other day with some wild stories about income sources and corporate greed. He also shared some of his recently harvested fruits and veggies.
Haha! I hear ya about Excel. It's certainly my personal preference! And I love your array math! :)
I did get the car washed, yes. It needs it again though! Hard to do with the twins these days. They're both teething. Oh the joys.
Smitty does have good harvests!
I did get the car washed, yes. It needs it again though! Hard to do with the twins these days. They're both teething. Oh the joys.
Smitty does have good harvests!
You could have a rummage/garage sale and make enough enough money to hire a sitter, drive the 150 miles to civilization, and dine at a swanky restaurant with the wifey...just with the crap in that car!
LOL!! It's closer to 200 miles to civilization. ;) I'm working on those income sources anyway. :)
ASKER
Thanks guys, so very much.
There is a larger amount of data (you were right it's not real data :) but it's doubtful that it will be put into an Access database although I will recommend it.
I do have a follow up question though...if I have a driver who speaks two languages, and a country that has multiple languages, will your array math still return the correct result? I can send over another example if you'd like.
There is a larger amount of data (you were right it's not real data :) but it's doubtful that it will be put into an Access database although I will recommend it.
I do have a follow up question though...if I have a driver who speaks two languages, and a country that has multiple languages, will your array math still return the correct result? I can send over another example if you'd like.
The formula will work and you already have a case for that: James Profows speaks two languages and drove through Canada which speaks two languages.
Kevin
Kevin
ASKER
Thanks!
If you're not planning on moving this to Access, I would recommend separating the data a little more. I don't know if this is your actual data or not. I suspect it is not. In any case, your data structure is going to become important, especially in larger quantities, so I recommend putting some thought into how you want this laid out.
@Kevin: heya!
Regards,
Zack