Inventory Tracking - Formula Needed
Picture 1 is my Transactions sheet, picture 2 is my Order sheet ETA: Excel 365 in Chrome browser. Screenshots are from Excel iPhone app - but all work is done via desktop.
I'm trying to pull a number from column G if the transaction ID in column I (picture 2) matches the TransID in column B (picture 1). I also want to make the number negative.
Example - T8 is an order of 5 clusters, each cluster is made of 3 different balloons plus a weight, hence the multiple T8 TransID, 1 per item. My sheet already uses the Quantity column in picture 2 to update an inventory sheet - that's why I need to make the number negative.
Is there a formula that can do this for me or am I completely overthinking this whole thing?
[link] [comments]
Want to read more?
Check out the full article on the original site