Hi, I have two tables like this:

This is for a home for elderly people.

The objective is for instance if Client1 restriction match any ingredient of food1 he cant eat that food.

I want to know for every client every food and then if is possible to make a table that says to me for instance food1 10 people can eat it, 12 dont. Or at least the name of the people who can and cant eat it.

I am using office 2011 on mac, but I halso have office 2013 on windows.

Thanks for the help!