Excel 2007 : Pivot's with Lookups or Indexes

Goal: to do as little work as possibly my self:...and get the dieticians to do it without knowing they are

1. Input in ORDER page by Hospital Dieticians
2. Inputs carried to LABEL DATA where it is set for formatting into template
3. LABEL for printing output for Diet Kitchen Staff to stick on supplements.
4. CORE DATA agreed wards, supplements, frequency and Qty ordered
5. STORES ISSUES output from RECIPES
6. RECIPES ---->"The Problem"

I can pull the Pivot of the ORDER's into a summary of the number of items to be produced...so far so good

I have setup the ingredients list that make up the supplements and the specs related to this.

where i get stuck is getting the vlookup / index / match [highlighted YELLOW] to compare the recipes to the PivotT table and increment the recipes by the Pivot count so as to calculate the STORES ISSUES

I would appreciate any help on this available...i just seem to not be able to get this one right

Thanks in Advance 4 Your Help

Gordon

Hi

See attached File

Hope it helps

Thanks for this, you make it look so simple, i cant believe that it was such a simple formula

Thanks again for the assist, much appreciated