Prev: Compile data from several workbooks
Next: Two Level Search
From: Jacob Skaria on 27 May 2010 16:28
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.
 | 
Pages: 1
Prev: Compile data from several workbooks
Next: Two Level Search