Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup vs. Match/Index | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
Index Match Vlookup? | Excel Discussion (Misc queries) | |||
VLookup or Index Match ? | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |