need excel formula to get result from data table depends upon week,partner,column values

[breadwinner]

dear experts

I have set of table data week wise i want get data as per week , partner name and name of header i want excel formula to get data from data table



i set the range for every partner. as per week wise and column header

i want set formula in to table cell link from table values

find the attachment....

[breadwinner]

any expert help on this?