Searching values from rows and columns and their multiplying (INDEX MATCH?)

[michavon]

Hello,
I'm trying again.
I would be really grateful if somebody could help me with a formula which I believe should be a combination of INDEX MATCH and SUMPRODUCT but I may be wrong
I have three spreadsheets:
The first spreadsheet is the Bill of Material (BOM) - products are in the row, semi-products are in the column, and values in cells are showing how many semi-products I need for the production of the product.
The second spreadsheet shows how many pcs of products I will dispatch on a particular day. Products are in the row, and dates are in the column.
The third spreadsheet should be the outcome. Semi-products are in the row, dates are in column. And I need to combine both spreadsheets into this one.
I need to see how many pcs of semi-products will be dispatched on a particular day using BOM = spreadsheet 1 and the dispatching schedule of the products = spreadsheet 2
For example 18.1. I will dispatch 3 pcs of 12117 which is on semi-product level 102000 2712 pcs (=904*3) and 103000 2682 pcs (=894*3).
18.1. I will also dispatch 5 pcs of 12076 => on semi-product level 101000 4245 pcs (=849*5) and 102000 4520 pcs (=904*5)
Thanks for any help.
I'm totally clueless here.

Michaela

 

[Peter_SSs]

Duplicate to: Summarize (multiplying and adding) data according to three conditions

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.