Hello Everyone,

Im here and need some help!

Im trying to make a basic inventory system on excel. Simply Matching SKU's on a sheet and subtracting the total from quantity.

My file looks like this... Sheet 1 is Master Inventory- column A is SKU, Column B is description, column C is Location, column H is quantity, column i is Price...

My goal is to have a blank cell to scan items, and the matching SKU in Column A should subtract the Quantity from the same row in column H,

I want when I pick a order and scan the barcode its should deduct the qty from the Inventory

I think this should be possible using the VLOOKUP function and/or match function.

Any help would help! Thanks!