I need to do a comparison in an Excel spreadsheet.
This is in relation to the first table seen at http://bit.ly/afSuXt
Look at the first row of the table.
I have 3 sets of numbers. Each set has 2 numbers. The figures for the Child set should have come from both the mather and the father - that is, one from the mother, and the other from the father. If not then return FALSE.
Comparison 1. Compare Child with Mother. Is at least one of the numbers in Child seen in Mother?
In the example above, yes - 14 in Child is also seen in Mother.
Comparison 2. If the Comparison 1 is TRUE, then compare Child and Father using the figure that does NOT match in Comparison 1. That is, compare the value of 15 in Child with both figures in Father. If it is seen, the return TRUE.
How can this be resolved? I've used LOOKUP, IF, AND, OR etc, but am looking for an elegant solution.