Reflecting figures + week number in separate table (Excel 2010)

[Frigocare]

Good day,

I have a table which consist of data in columns, most important is quantity under X,Y,Z and expire date week (which is formula <WEEKNUM> from expire date, already set)

brand	from	X	Y	Z	remaining qty	to	Request date	Expire date	Expire date week	Free days	SLO ref
ABC	Tokyo			10		FIHELFS	12/06/2015	10/07/2015	28	28	800000108879
ABC	Tokyo			3		FIHELFS	12/06/2015	10/07/2015	28	28	800000108880
ABC	Tokyo			5		FIKTKCS	12/06/2015	10/07/2015	28	28	800000108881
ABC	Tokyo			10		FIHELFS	12/06/2015	10/07/2015	28	28	800000108903

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Now i want to reflect above important data into separate smaller table which shows quantity per X,Y,Z for incoming 3 weeks to "to proper location" in this case FIHELFS and FIKTKCS

looks as below:

	WEEK	X	Y	Z
FIHELFS	26
	27
	28
FIKTKCS	25
	26
	27

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

so it basically need some kind of IF formula, to reflect quantity of X or Y or Z under week 26, 27 or 28 to correct location ?

Can You provide any tips ? I dont think so it will be difficult for experienced user, however i need a light in a tunnel

Greetings,
Filip