Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
current stock formula help?
Hi,
I am running Office 2007 and I am trying to find a formula that will allow me to lookup the amount of stock used and subtract it from the starting amount. It must be noted that the stock used does not appear in alphabetical order and there are blank spaces in the stock used column due to the stock being in groups according to creation made. The base Stock list is in alphabetical order. I have tried a VLOOKUP but it seems to only return one of the results and does not add together all of the stock of that ID used. Pages are named "Stock" & "Creations". All stock has been allocated an ID number in column A and this is consistant across both sheets. Start count is located in Stock!C:C Stock Used is located in Creations!C:C Stock remaining should end up in Stock!D:D Thanks for your help. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock purchasing SS formula help needed. | Excel Discussion (Misc queries) | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel | Excel Worksheet Functions | |||
Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers | Excel Worksheet Functions | |||
Stock Stop Loss Formula | Excel Discussion (Misc queries) |