I have a workbook setup just like this (below) except it has everyday in
2005. When I do a vlookup I have it lookup according to Week # because that
is the line with weekly totals of what I need. I can get the lookup to work
but only up to Week # 13 and the it just repeats Week 13 over and over again.
What might be causing this?

Please help! thanks in advance.



Week of 1/3/2005
1/3 Mon
1/4 Tue
1/5 Wed
1/6 Thu
1/7 Fri
1/8 Sat
1/9 Sun
Week # 1
Week of 1/10/2005
1/10 Mon
1/11 Tue
1/12 Wed
1/13 Thu
1/14 Fri
1/15 Sat
1/16 Sun
Week # 2
Week of 1/17/2005
1/17 Mon
1/18 Tue
1/19 Wed
1/20 Thu
1/21 Fri
1/22 Sat
1/23 Sun
Week # 3