vlookup, match/index ????
 

Column A - Date
Column C - Beginning Inventory Level(litres)
Column D - Purchases(litres)
Column E - Cost per litre
Column F - Sales(litres)

01/15/06 10000 5000 0.855 1100
01/16/06 13900 0 0 2000
01/17/06 11900 5500 0.840 7500
01/18/06 9900 0 0 5000

I am trying to reconcile the inventory on a different worksheet
I can come up with the inventory level with a vlookup on the date.
What I can't figure out is how to pick up the Purchases and Cost that
make up the inventory level.

Inventory Level 9900
Made up of;
5500 0.840
4400 0.855
Total 9900

TIA Gerry