Forum Discussion
Inventory Qty Update Formula
I have a workbook with 3 tabs - Inventory Sheet, Mat Log, Cost Tracking.
The cost tracking sheet had the original inventory amount that we need to start with (Column J).
On the Mat Log sheet, when an item is removed or added to inventory, the person will enter the date in column A, the Mat. Code in Column B - and that will populate the name in Column C. Column F is the amount they are taking out (negative number) or putting into inventory (positive number). Here is where the "I need help" comes in. On the inventory sheet, I need the quantity associated the product code to always be updated based on what happens on the Mat Log sheet.
Use this formula:
=VLOOKUP([@[Mat. Code]], 'Cost Tracking'!$A$2:$J$45, 10, FALSE)+SUMIFS(Inventory_tracker1_2[Amount Taken], Inventory_tracker1_2[Mat. Code], [@[Mat. Code]])
I am now getting an error message - Formula Parse error - the value does not match the column type number. I made sure that all 3 columns are formatted as numbers?? I guess I should have also said this was a google sheet. I downloaded it to Excel so I didn't mess up anything in the google sheet. Should the formula read differently being in a Google Sheet?
I'm sorry, I have very little experience with Google Sheets.
