Hi guys,

Here's a question that while straightforward I am stuck with in terms
of carrying it out in Excel:

I have three groups of values - say Letters (A, B, C), Numbers
(1,2,3,4) and Variables (x,y,z). I have two true-false relationships
between two pairs - say Letters-Numbers and Letters-Variables and I
would like to know the remaining relationship i.e. Variables-Numbers.

- Say Letters-Numbers is thus (where the value of a cell can either be
1-true or 0-false):

1 2 3 4
A 1 0 0 1
B 0 0 0 1
C 0 1 1 0

- And Letters-Variables is thus:

x y z
A 0 1 0
B 1 0 0
C 0 0 1

- I am trying to find the combination Variables-Numbers thus (Where
the logic is: If "1" in "A" is TRUE and "A" in "y" is TRUE then "y" in
"1" is TRUE):

1 2 3 4
x 0 0 0 1
y 1 0 0 1
z 0 1 1 0

Any help on this one would be very, very appreciated!

Cheers,
Edu