vlookup, match/index ????
 

I'm trying to set up a workbook that shows the cost of fuel sold each
day. This has to be taken from the inventorly levels and use the
correct price, using FIFO.
Column A is the running total of purchases(litres). Column B is Daily
purchases(litres), Column C is cost per litre and Column D is litres
sold daily. In column E, I would like to show the actual cost per litre
for the litres sold daily.

Running Total Purchases Cost Litres Sold
Cost of Litres Sold
6000(on hand) 0.895 4000
0.895
9000 3000 0.925 4000
0.910(this would be a combination of the 2 costs)
12500 3500 0.950 1000
0.925
12500
2000 0.950


TIA
Gerry

vlookup, match/index ????
 

your table is very confusing, and is hard to decipher - please clarify
layout again.

Cheers,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=486842

vlookup, match/index ????
 

Hopefully this will show up better

A B C D E
6000(on hand) 0.895 4000 0.895
9000 3000 0.925 4000 0.910(this would be
a combination of the 2 costs)
12500 3500 0.950 1000 0.925
12500 2000 0.950

Gerry