Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find value with two conditions
Hi,
I am trying to find a value in the follwoing sheet "AO1 1-2009". I want to find the number 500 and put it in another sheet. A B C 1 2 3 2 100 50 52 3 101 300 500 I have been trying to do this the following way =SUMPRODUCT((101='AO1 01-2009'!$A$2:$A$45)*(3='AO1 01-2009'!$A$1:$C$1)*('AO1 01-2009'!C2:C45)) However, I guess if you use sumproduct for conditions in different ranges it does not work. Please help me out! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find value with two conditions
One way:
A1 = 101 B1 = 3 =VLOOKUP(A1,'AO1 01-2009'!A1:C10,MATCH(B1,'AO1 01-2009'!A1:C1,0),0) -- Biff Microsoft Excel MVP "Verlaesslichkeit" wrote in message ... Hi, I am trying to find a value in the follwoing sheet "AO1 1-2009". I want to find the number 500 and put it in another sheet. A B C 1 2 3 2 100 50 52 3 101 300 500 I have been trying to do this the following way =SUMPRODUCT((101='AO1 01-2009'!$A$2:$A$45)*(3='AO1 01-2009'!$A$1:$C$1)*('AO1 01-2009'!C2:C45)) However, I guess if you use sumproduct for conditions in different ranges it does not work. Please help me out! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find the value with 2 conditions? | Excel Discussion (Misc queries) | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
How do I handle error conditions with the FIND command? | Excel Worksheet Functions | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions |