help if and macros

[marcelo2112]

I got a list of clients that have food restriction like this:

Client	Restriction1	Restriction2	Restriction3	Restriction4	Restriction5
Zed	Rice	Pasta	Fish	Fried Food	Apples
Charles	Rice	Fish	Fried Food
Carl

<tbody>
</tbody>

And a list of foods that I serve in my company like this:

Food	ingredient1	ingredient2	ingredient3	ingredient4	ingredient5
Food1	Rice	Pasta	Fish	Fried Food	Apples
Food2	Pasta	Meat	Fried Food
food3	Cheese

<tbody>
</tbody>

I wanted to know if is it possible to make a table for instance or of the number of people that cant eat food1 or food2, or what persons cant eat food1 or food2, or food3

Is a big emergency!!
Thanks for the help

 

[alansidman]

Have you considered my solution which requires you to set up your data in a normalized database format that will allow for ease of matching the two tables. If this is going to get to be a large file of multiple restrictions and menus, I would seriously consider normalizing the data and explore using Access for the data base.

 

[marcelo2112]

Hi
I have make the two normalized tables for the meals and the clients that I used their company number.
But I cant make the query, I dont know why.
I am working on MS office for mac 2011, but also have the office 2013 for windows.

I will send you a link with the workbook if you could see it if is ok and if you can help with the query, it would be great.
In the workbook there is also a table with an example of what results I need.
Thank you again!

https://www.dropbox.com/s/b3p50q4573muz1d/Alimentation_v2.xlsx?dl=0

 

[alansidman]

I have taken your file. I moved the restrictions table to a new sheet. I then applied a query to the two tables using MSQuery which is included in at least your 2013 version of Excel. I don't know MAC. I have exported the MS Query file and your file with the results showing which nrs in the restrictions table cannot eat the meals from the meal table.

Here is the link to both files. https://app.box.com/s/7zfp6oaohrxi1b054tvt

 

[marcelo2112]

Thank you!
This is what I want!
If I want to make any change I have work only with the excel or the database file?
Realy thanks for the support!

I have taken your file. I moved the restrictions table to a new sheet. I then applied a query to the two tables using MSQuery which is included in at least your 2013 version of Excel. I don't know MAC. I have exported the MS Query file and your file with the results showing which nrs in the restrictions table cannot eat the meals from the meal table.

Here is the link to both files. https://app.box.com/s/7zfp6oaohrxi1b054tvt