I have two sheets. On one sheet I have products and inventory taken on
different days:

A1 B1 C1
05/08/07 Product1 1300
05/08/07 Product2 560
30/08/07 Product1 685
30/08/07 Product3 1513
05/09/07 Product3 669
05/09/07 Product1 1754
05/09/07 Product2 555

On sheet two I want to retrieve the most recent inventory for each product
as well as the corresponding date.

A1 B1 C1
Product1 1754 05/09/07
Product2 555 05/09/07
Product3 669 05/09/07

Does anyone know what formulas I would use to do this? I'm using Excel 2000.