Hello,
I am trying to create a spreadsheet which tracks inventory. So far I have set up the items and quantities and now I am trying to create a formula to do this process. I plan to scan the barcode for the item and have Excel recognize the corresponding barcode and then subtract it from the original quantity.
This formula doesn't work but it shows what I am trying to achieve:
ItemaaaaaaaQuantityaaaaaaBarcodeaaaaaaaRemainder
XYZaaaaaaaa5aaaaaaaaa130-001aaaaaaaaaa =B2-(whenscanned=C2)then1

I'm not entirely sure this is even possible.
It would be great if anyone has done something like this before or someone just up for a challenge to find a way to do this.
I am going to keep trying to solve this and I'll post again if I find a solution.
Thank you for your help