Excel - Matching outgoing to incoming inventory based a specific conditions

Hello,   I wonder if anyone here can help me.  I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced eac...