Returning a value if multiple conditions are met

Try the below in cell D1..with data in Sheet1 and query values in current
sheet A:C..

=INDEX(Sheet1!$D$1:$D$10,SUMPRODUCT((Sheet1!$A$1:$ A$10=A1)*
(Sheet1!$B$1:$B$10=B1)*(Sheet1!$C$1:$C$10=C1),ROW( $A$1:$A$10)))

--
Jacob (MVP - Excel)


"Joel" wrote:

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.