Excel - Matching outgoing to incoming inventory based a specific conditions

It sounds like you’ll need a setup where your outgoing pieces are matched to the earliest open shipment until it closes. A running balance usually does the trick subtract from each batch as items go out and once it hits zero you can mark it Closed, if it’s partly used mark it In Progress, and if untouched leave it Open. A mix of formulas like SUMIFS or INDEX/MATCH with maybe a helper column can keep it organized.