Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a value if multiple conditions are met
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a value if multiple conditions are met
Assuming your table in A2:D9, and your criteria in F2:H2
=index($D$2:$D$8,match(1,($A$2:$A$8=$F$2)* ($B$2:$B$8=$G$2)*($C$2:$C$8=$H$2,0)) should give the correct result. "Joel" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a value if multiple conditions are met
Hi,
Try this. A2:C9 is your data range. A15:C15 is the select table =sumproduct(($A$2:$A$9=$A15)*($B$2:$B$9=$B15)*($C$ 2:$C$9=$C15)*($D$2:$D$9)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Joel" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a value if multiple conditions are met | Excel Worksheet Functions | |||
returning blank cell when conditions not met | Excel Worksheet Functions | |||
Returning a Value if 3 Conditions are True | Excel Worksheet Functions | |||
returning a count if two conditions are met | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |