Can I use VLookup with multiple lookup values?

[shonu1320]

Hi,

I want to find out if I can use Vlookup with 2 different lookup value? Or I should use some other function for the same?
For example below is my table from where I want to find unit price. I have three columns(part#, order date and Unit price) and 7 rows.

A B C
1 Part Number Order Date Unit Price
2 6003 4/28/10 .53
3 5/5/10 .51
4 5/11/10 .5321
5 5/12/10 .52
6 5/18/10 .51
7 5/19/10 .53
8 5/26/10 .51

In the table where I am working, I have the part number and order date. I want to find unit price by looking up part number and order date both because of fluctuation in price almost daily.
But with vlookup, I can only look up part number to find unit price, which gives me a value of .53(very first value for that part). However, if my order date is 5/5/10, I still get .53 as unit price instead of .51

Any thoughts? Any help on this will be greatly appreciated. Thanks!

[judgeh59]

There are 2 techniques I know of....one is the INDEX/MATCH combo and the other is SUMPRODUCTS function...I can show the INDEX/MATCH or you could search on the INDEX/MATCH multiple lookups here....let me know how you would like to proceed....