vlookup within vlookup or similar function in google docs (Excel)

please note this is google docs project the solution has to be done in google docs sheet.

see attached xls example.

Its a Production Plan for each CalendarWeek 1-52

In Sheet KW1-36 and KW37-52 i need the data from Sheet Orlando how many PCS have to be producted.

For Example Calenderweek 24 put Data from Orlando column C into column FG (of course correct quantity for each Model/Product)

Usually this can be easily done with VLookup BUT some of the data has to be accumulated:

EXAMPLE FOR KW24

Orlando:

Model

Koblenz Links 18 PCS

Koblenz Rechts 11 PCS

but KW1-36 has only

KOBLENZ so we have to Put the value (18+11) = 29

which models are to be accumulated is defined in Sheet Reference Table

i have started to give them ids but i still dont know how to solve this.

so we need to get data from Orlando - look in Reference Table - accumulate - put in KW1-36 or KW37-52 this is depending on the CalendarWeek == CW == KW

the table Oralndo is every day updated by copy-paste (from ERP softeware) because the demands of customers are changing every day: The models and the CalendarWeeks are never fixed !!. It can also happen that we onyl have to produce 3 different models for e.g. KW50, KW51, KW52

i need it as fast as possible.

Excel

Project ID: #4614623

About the project