Hello, I'm new here and would request for some help.

I have multiple formulations (i.e, mix of 5 to 6 different items from an inventory).

I would like to create a formula to deduct my inventory based on the formulations for each the items sold.

So for example, I would have Item1 (with a mix of 4 items from the inventory) and Item2 (with a mix of 6 items from the inventory); when I sell item1 and item2, I would like to reduce the inventory based on their respective formulations.

My Sale and Inventory items are on 2 different worksheets.

Would appreciate any help and feedback on how to resolve this.

Thank you for your time and effort.