I am trying to develop a method which will return a value if each of three
conditions are met. The three conditions, each with a differing number of
possibilities, are set in three columns and for each permutation there is a
value associated with it.
I would then like to set up a drop down list for each condition from which
to select the possibility of each and have the value for that combination of
conditions returned to an adjacent cell.
Example:
Conditions A B C Value
possibilities 1 x a 1
1 y a 2
1 x b 3
1 y b 4
2 x a 5
2 y a 6
2 x b 7
2 y b 8


Select: A B C Result
2 x b 7
1 y a 2

Any help with this problem would be greatly appreciated.