Spreadsheet: 196692d1354076257-vlookup-guidance-test-1
Sheet: Sheet5

Year | WEEK | Guests | Average days
2009-12-01 00:00:00 | WEEK 1 | 150 | 17.16129032258064
2009-12-01 00:00:00 | WEEK 2 | 136 | 27.2
2009-12-01 00:00:00 | WEEK 3 | 139 | 21.15151515151515
2009-12-01 00:00:00 | WEEK 4 | 113 | 21.25
2009-12-01 00:00:00 | WEEK 5 | 74 | 17.92
2010-12-01 00:00:00 | WEEK 1 | 210 | 24.81481481481481
2010-12-01 00:00:00 | WEEK 2 | 269 | 19.2741935483871
2010-12-01 00:00:00 | WEEK 3 | 213 | 26.35714285714286
2010-12-01 00:00:00 | WEEK 4 | 268 | 21.24193548387097
2010-12-01 00:00:00 | WEEK 5 | 232 | 16.33333333333333
2011-12-01 00:00:00 | WEEK 1 | 148 | 18.22857142857143
2011-12-01 00:00:00 | WEEK 2 | 104 | 29.29032258064516
2011-12-01 00:00:00 | WEEK 3 | 139 | 25.21212121212121
2011-12-01 00:00:00 | WEEK 4 | 229 | 33.87931034482759
2011-12-01 00:00:00 | WEEK 5 | 78 | 44.27586206896552
2012-12-01 00:00:00 | WEEK 1 | 56 | 21.88888888888889
2012-12-01 00:00:00 | WEEK 2 | 66 | 23.82352941176471
2012-12-01 00:00:00 | WEEK 3 | 65 | 41
2012-12-01 00:00:00 | WEEK 4 | 40 | 51
2012-12-01 00:00:00 | WEEK 5 | 8 | 45.25
2010-02-01 00:00:00 | WEEK 1 | 102 | 20.5
2010-02-01 00:00:00 | WEEK 2 | 116 | 13.62222222222222
2010-02-01 00:00:00 | WEEK 3 | 76 | 13.96
2010-02-01 00:00:00 | WEEK 4 | 67 | 30.27777777777778
2011-02-01 00:00:00 | WEEK 1 | 94 | 16.74193548387097
2011-02-01 00:00:00 | WEEK 2 | 184 | 13.14285714285714
2011-02-01 00:00:00 | WEEK 3 | 156 | 18.75409836065574
2011-02-01 00:00:00 | WEEK 4 | 101 | 22.775
2011-02-01 00:00:00 | WEEK 5 | 13 | 9
2012-02-01 00:00:00 | WEEK 1 | 74 | 18.27586206896552
2012-02-01 00:00:00 | WEEK 2 | 120 | 27.75
2012-02-01 00:00:00 | WEEK 3 | 153 | 22.27450980392157
2012-02-01 00:00:00 | WEEK 4 | 114 | 25.45161290322581
2012-02-01 00:00:00 | WEEK 5 | 8 | 4.5
2013-02-01 00:00:00 | WEEK 4 | 4 | 133
2013-02-01 00:00:00 | WEEK 5 | 3 | 108
2010-01-01 00:00:00 | WEEK 1 | 82 | 27.42857142857143
2010-01-01 00:00:00 | WEEK 2 | 110 | 17.13513513513514
2010-01-01 00:00:00 | WEEK 3 | 106 | 13.66666666666667
2010-01-01 00:00:00 | WEEK 4 | 56 | 12.95454545454546
2010-01-01 00:00:00 | WEEK 5 | 69 | 23.33333333333333
2011-01-01 00:00:00 | WEEK 1 | 179 | 21.58
2011-01-01 00:00:00 | WEEK 2 | 162 | 18.71428571428572
2011-01-01 00:00:00 | WEEK 3 | 158 | 18.66666666666667
2011-01-01 00:00:00 | WEEK 4 | 157 | 17.67924528301887
2011-01-01 00:00:00 | WEEK 5 | 83 | 16.03448275862069
2012-01-01 00:00:00 | WEEK 1 | 142 | 15.91111111111111
2012-01-01 00:00:00 | WEEK 2 | 96 | 17
2012-01-01 00:00:00 | WEEK 3 | 67 | 18.84
2012-01-01 00:00:00 | WEEK 4 | 119 | 20.16216216216216
2012-01-01 00:00:00 | WEEK 5 | 68 | 22.76190476190476
2013-01-01 00:00:00 | WEEK 1 | 19 | 114.1666666666667
2013-01-01 00:00:00 | WEEK 2 | 13 | 91
2013-01-01 00:00:00 | WEEK 3 | 2 | 212
2013-01-01 00:00:00 | WEEK 4 | 6 | 66
2009-11-01 00:00:00 | WEEK 1 | 53 | 17.75
2009-11-01 00:00:00 | WEEK 2 | 75 | 18.47826086956522
2009-11-01 00:00:00 | WEEK 3 | 146 | 23.86842105263158
2009-11-01 00:00:00 | WEEK 4 | 81 | 22.54545454545455
2009-11-01 00:00:00 | WEEK 5 | 48 | 14.17647058823529
2010-11-01 00:00:00 | WEEK 1 | 153 | 18.43636363636364
2010-11-01 00:00:00 | WEEK 2 | 183 | 18.36363636363636
2010-11-01 00:00:00 | WEEK 3 | 209 | 22.28985507246377
2010-11-01 00:00:00 | WEEK 4 | 255 | 18.22727272727273
2010-11-01 00:00:00 | WEEK 5 | 37 | 19.93333333333333
2011-11-01 00:00:00 | WEEK 1 | 82 | 14.82758620689655
2011-11-01 00:00:00 | WEEK 2 | 107 | 29.83333333333333
2011-11-01 00:00:00 | WEEK 3 | 104 | 27
2011-11-01 00:00:00 | WEEK 4 | 125 | 24.53571428571428
2011-11-01 00:00:00 | WEEK 5 | 58 | 21.7
2012-11-01 00:00:00 | WEEK 1 | 85 | 25.70833333333333
2012-11-01 00:00:00 | WEEK 2 | 125 | 28.45945945945946
2012-11-01 00:00:00 | WEEK 3 | 91 | 19.13793103448276
2012-11-01 00:00:00 | WEEK 4 | 113 | 11.17647058823529
2012-11-01 00:00:00 | WEEK 5 | 38 | 19
 |  | 7984
Table A | Average days
 | 2009-11-01 00:00:00 | 2010-11-01 00:00:00 | 2011-11-01 00:00:00 | 2012-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-12-01 00:00:00 | 2011-12-01 00:00:00 | 2012-12-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-02-01 00:00:00 | 2010-02-01 00:00:00 | 2011-02-01 00:00:00 | 2012-02-01 00:00:00 | 2013-02-01 00:00:00
Week 1 | 17.75 | 18.43636363636364
Week 2 | 18.47826086956522 | 18.36363636363636
Week 3 | 23.86842105263158 | 22.28985507246377
Week 4 | 22.54545454545455 | 18.22727272727273
Week 5 | 14.17647058823529 | 19.93333333333333
 | Goal:
 | Look week (yellow) pick up data from "average days" and put under respective month with year
 | I have manually put under Nov 09 and Nov 10 from above columns
 | Instaed maunally use vlookup to fill in  Table A
 | Thanks!!
Table B | Guest
 | 2009-11-01 00:00:00 | 2010-11-01 00:00:00 | 2011-11-01 00:00:00 | 2012-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-12-01 00:00:00 | 2011-12-01 00:00:00 | 2012-12-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-02-01 00:00:00 | 2010-02-01 00:00:00 | 2011-02-01 00:00:00 | 2012-02-01 00:00:00 | 2013-02-01 00:00:00
Week 1 | 53 | 153
Week 2 | 75 | 183
Week 3 | 146 | 209
Week 4 | 81 | 255
Week 5 | 48 | 37