right vlookup/index formula in excel to match weeks and dates

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	18-Jul	16-Jul	23-Jul	30-Jul	6-Aug	13-Aug	20-Aug	27-Aug	3-Sep	10-Sep	17-Sep	24-Sep	1-Oct	8-Oct	15-Oct	22-Oct	29-Oct	5-Nov	12-Nov	19-Nov	26-Nov	3-Dec	10-Dec	17-Dec	24-Dec	31-Dec	7-Jan	14-Jan	21-Jan	28-Jan	4-Feb	11-Feb
2	N6746601					25					0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
3	N6746701					75					0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
4	N6746801										0	0	0	0	0	0	0	0	25	0	0	0	0	0	0	0	0	0	0	0	0	0
5	N6746901					40					0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
6	N6764501					50					0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7	N6764601					25					0	0	0	0	0	0	0	0	25	0	0	0	0	0	0	0	0	0	0	0	0	0
8	N6764701					25					0	0	0	0	0	0	0	0	100	0	0	0	0	10	0	0	0	0	0	0	0	0
9	N6760201					25					0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
10	N6760301					25					0	0	0	0	50	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
11	N6760401					25					0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
12	N6749401		1925								0	0	0	0	0	0	0	0	1000	0	0	0	0	0	0	0	0	0	0	0	0	0
13	N6749501		525								0	0	0	0	0	25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
14	N6749601		100								0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
15	N6749701			50							0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
16	N6749801		2055								0	0	0	135	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
17	weeknum	29	30	31	32	33	34	35	36	37	38	39	40	41	42	43	44	45	46	47	48	49	50	51	52	53	1	2	3	4	5	6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100