=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
|