Hello everyone,

I'm wondering if I could use some sort of Sumif or Sumproduct formula for
this with a few if's. Let me know if you agree and if you could have a
helpfull hint. I was going to do this with access, but perhaps its best with
Excel

I'am so stumped.

I have a spreadsheet with item numbers, and the parts that are used in the
items like so
item plastic balls staples
12345 2 4
67890 0 5
And theres many more parts,

and then I have a monthly projected demand by item spreadsheet, with the
item number and the monthly demand like so
item jan feb
12345 20 22
67890 2 15

So now, how do I get a query done that will bring back the parts in a row,
then months as the column headings with the quantities that I will need for
each month once the query figures out that a part belongs to an item then it
multiples the quantity that item needs of a part times the fcst for that
month. I hope someone can help.