Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |