Find the latest selling price from a product list for selected customer

I have a table with raw data as below :

Customer Code Product Code Date Selling Price
AAL001 EWMT 1327 02/08/2012 1.3
AAL001 EWMT 3250 27/11/2012 4.3
AAL001 EWMT 50100 27/11/2012 19.7
AAL001 EWMT 50100 24/07/2013 19.8
AAL001 EWMT 5050 22/01/2013 5.55
FS005 EWMT 3250 02/08/2011 1.25
FS005 EMWT 3250 02/08/2012 1.30
ZS003 EWMT 50100 01/08/2011 19.7
ZS003 EWMT 50100 01/08/2012 19.8

Then I have a separate sheet identify by customer and a full list of Product
Sheet for Customer :AAL001
Product Code Last Selling Price Last Selling Date
EWMT 1320 n/a n/a
EWMT 1327 1.3 02/08/2012
EWMT 3200 n/a n/a
EWMT 3250 4.3 27/11/2012
EWMT 5000 n/a n/a
EWMT 5050 5.55 22/01/2013
EWMT 50000 n/a n/a
EWMT 50100 19.8 24/07/2013
EWMT 50200 n/a n/a

Pls advise.

Hi and welcome to the forum.

Looks like to need a compination of INDEX & MATCH with MAX function, but:

Be sure that best way to describe your problem is to upload a sample workbook.

Be sure that all sensitive data removed, showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that.

To attach a small sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

welcome to the forum, wesleyho . next time, do upload a sample excel file so that we do not have to re-create your file to test it out. see if the attached file helps. to simulate the scenario where it is in another sheet, just cut my data from H1:L10 & paste in sheet2.

Ben's suggestion must works for you. Doesn't it?

This is what I want! !!
Thanks a lot!!!

See also another alternative solution..

=INDEX(RAW!$D$2:$D$10;MATCH(MAX(IF(RAW!$A$2:$A$10=$A$1;IF(RAW!$B$2:$B$10=A3;RAW!$C$2:$C$10)))&$A3;RAW!$C$2:$C$10&RAW!$B$2:$B$10;0))