I am trying to set up a stock ordering system for my new business. I sell
gift hampers. The hamper is made up of several products. So, for example, I
have sold 1 'sweet' basket [column B] I need the applicable columns that
represent the individual items in the hamper [C - G] to automatically show
quantities. Am I asking for the impossible. In my head it works. I am used
to formulas going the other way. I would appreciate your feedback.