Finding a date based on two matching criterias.

[might_be_high]

Back again with another noob question.

I have a workbook with two sheets. On the first, I have columns with information including Sales Part Number (criteria 1) and Delivery Customer Name (criteria 2). I have both of these criterias are column headers on a second sheet, but it also has the estimated ship date. How can I find the shipping date if the part number and the customer name match and place the date in a colium back on sheet1? Vlookup? Match?

I have attached an example workbook to a reply below.

[alansidman]

Please upload your sample file to this forum site. Many of our users are reluctant to download files from other sites fearing malware. Click on the Go Advanced Button in the reply window and scroll down to Manage Attachments.

[might_be_high]

I have attached an example file below. Any help would be appreciated.

[Phuocam]

Try this ...

=INDEX(Sheet2!$C$2:$C$8,MATCH(A2&"#"&C2,INDEX(Sheet2!$A$2:$A$8&"#"&Sheet2!$B$2:$B$8,0),0))

Or:

=LOOKUP(2,1/(A2=Sheet2!$A$2:$A$8)/(C2=Sheet2!$B$2:$B$8),Sheet2!$C$2:$C$8)

[might_be_high]

Phuocam - THANK YOU!

For anyone looking for an answer. Both work. Index appears to work better on large data files.