Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I look up two seperate values/cells and return the value .
I would like to do two VLOOKUP type functions and have it return the value in
the third column. For instance, if I have an array something like this: Purple Grape 5 Green Grape 9 Orange Lemon 2 In the spreadsheet I have: A B C Purple Grape ? I would like to say if A and B match then give me C. Thanks |
#2
|
|||
|
|||
One way
=INDEX(C2:C2000,MATCH(1,(A2:A2000="Purple")*(B2:B2 000="Grape"),0)) entered with ctrl + shift & enter you should replace the criteria with cells (replace Grape and Purple woith 2 cells where you type the criteria, that way you don't have to edit the formula when you want to change lookup values) Regards, Peo Sjoblom "Barbara" wrote: I would like to do two VLOOKUP type functions and have it return the value in the third column. For instance, if I have an array something like this: Purple Grape 5 Green Grape 9 Orange Lemon 2 In the spreadsheet I have: A B C Purple Grape ? I would like to say if A and B match then give me C. Thanks |
#3
|
|||
|
|||
=INDEX(C1:C3,MATCH("purple",A1:A3,0),MATCH("grape" ,B1:B3,0))
"Barbara" wrote in message ... I would like to do two VLOOKUP type functions and have it return the value in the third column. For instance, if I have an array something like this: Purple Grape 5 Green Grape 9 Orange Lemon 2 In the spreadsheet I have: A B C Purple Grape ? I would like to say if A and B match then give me C. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
VLookup Return Value | Excel Worksheet Functions | |||
Automatic return in an excel worksheet | Excel Worksheet Functions | |||
Return the end of month date from a date | Excel Worksheet Functions | |||
VBA: Return Searched Value Inputed by End-User | Excel Worksheet Functions |