Emoncada
08-27-2008, 09:22 AM
I have 3 worksheets in one spreadsheet.
Incoming, Outgoing, Totals
In "Totals" Sheet I want to start with a Qty
for a list of Items 55 Items
Column A...........Column B...........Column C
Models............Start Inventory........Qty
6408..................50.......................50
T7316.................27.......................27
6408D.................42.......................42
8434DX...............70.......................70
etc..
I want column C to have some type of formula that can do a vlookup for the value Column A (example "6408") and look at The "Incoming" Sheet and look for any rows that have "6408" then add The "Incoming" Sheet Column B for those rows and add it to Column C. Same Thing for Outgoing except instead of add it, it would be subtract it.
Hope that explains my goal.
Incoming, Outgoing, Totals
In "Totals" Sheet I want to start with a Qty
for a list of Items 55 Items
Column A...........Column B...........Column C
Models............Start Inventory........Qty
6408..................50.......................50
T7316.................27.......................27
6408D.................42.......................42
8434DX...............70.......................70
etc..
I want column C to have some type of formula that can do a vlookup for the value Column A (example "6408") and look at The "Incoming" Sheet and look for any rows that have "6408" then add The "Incoming" Sheet Column B for those rows and add it to Column C. Same Thing for Outgoing except instead of add it, it would be subtract it.
Hope that explains my goal.