Excel Index & Match vertical and horizontal criteria for copying formula

[js_01]

I have been trying to populate the following table: Final_table with order_amount from the Orders_table:

I cannot crack the fact there is a second condition to be taken into account - column delivery_week. Can somebody please help me out with a formula so it can be used across the weeks in table Final? I have tried with Index+Match. The issue is, one condition is to be looked up horizontally (product_id) and second (Deliver_week) vertically.

The end result is shown here: End_state

I would appreciate any tips.. PS: The table structure has to stay as it is - shown tables are just necessary columns to solve the problem.

 

[Fluff]

Hi & welcome to MrExcel.
You can use the SUMIFS function

SUMIFS Function

The Excel SUMIFS function returns the sum of cells that meet multiple conditions, referred to as criteria. To define criteria, SUMIFS supports logical operators (>,

exceljet.net

 

[Fluff]

Cross posted Excel Index & Match vertical and horizontal criteria for copying formula

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.