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, whe...
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.
