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