Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to lookup based on a condition of two values
I have three columns A, B and C.
I want too look up the value in C where A and B match different values. Example: A, B ,C apple, color, green apple , price, 30 lemon, taste, tangy lemon, price 20 I want to lookup A=apple B=price to return the price 30. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to lookup based on a condition of two values
Assuming that the combination of A + B is unique...
=SUMPRODUCT(--(A2:A10="apple"),--(B2:B10="price"),C2:C10) Better to use cells to hold the criteria. E2 = apple F2 = price =SUMPRODUCT(--(A2:A10=E2),--(B2:B10=F2),C2:C10) -- Biff Microsoft Excel MVP "Trying to lookup based on a condition of" <Trying to lookup based on a condition wrote in message ... I have three columns A, B and C. I want too look up the value in C where A and B match different values. Example: A, B ,C apple, color, green apple , price, 30 lemon, taste, tangy lemon, price 20 I want to lookup A=apple B=price to return the price 30. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf Condition based on lookup in a list of values | Excel Worksheet Functions | |||
Sum table values based on condition | Excel Worksheet Functions | |||
How to average values based on a condition in another column | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Cannot sum values based on condition | Excel Worksheet Functions |