What I have:										
Issue	DOI	8/31/2008	9/7/2008	9/14/2008	9/21/2008	9/28/2008	10/5/2008	10/12/2008	Total	Rank
64_1	faj.v64.n1.12	11	15	1	3	1	0	1	"=SUM(table_64[[#This Row],[8/31/2008]:[10/12/2008]])"	9
64_2	faj.v64.n2.11	0	16	8	2	1	2	5	"=SUM(table_64[[#This Row],[8/31/2008]:[10/12/2008]])"	8
64_3	faj.v64.n3.15	0	0	12	7	2	4	2	"=SUM(table_64[[#This Row],[8/31/2008]:[10/12/2008]])"	7
64_4	faj.v64.n4.5	0	0	0	26	6	4	5	"=SUM(table_64[[#This Row],[8/31/2008]:[10/12/2008]])"	7
64_5	faj.v64.n5.6	0	0	0	0	27	15	33	"=SUM(table_64[[#This Row],[8/31/2008]:[10/12/2008]])"	6
64_6	faj.v64.n6.9	0	0	0	0	0	37	48	"=SUM(table_64[[#This Row],[8/31/2008]:[10/12/2008]])"	6
										
What I want:										
DOI	Live Date	Week 1	Week 2	Week 3	Week 4	Week 5				
faj.v64.n1.12	8/31/2008	11	15	1	3	1				
faj.v64.n2.11	9/7/2008	16	8	2	1	2				
faj.v64.n3.15	9/14/2008	12	7	2	4	2				
faj.v64.n4.5	9/21/2008	26	6	4	5					
faj.v64.n5.6	9/28/2008	27	15	33						
faj.v64.n6.9	10/5/2008	37	48							
										
Starting thoughts…		0	7	14						
Issue	Live Date	Week 1	Week 2	Week 3	Notes					
faj.v64.n1.12	8/31/2008	"=HLOOKUP($B21, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A21, table_64[[#All],[DOI]], 0), TRUE)"	"=HLOOKUP($B21+E$19, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A21, table_64[[#All],[DOI]], 0), TRUE)"		hlookup + match works if I copy the header cells from table_64					
faj.v64.n2.11	39698	"=HLOOKUP($B22, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A22, table_64[[#All],[DOI]], 0), TRUE)"	"=HLOOKUP($B22+E$19, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A22, table_64[[#All],[DOI]], 0), TRUE)"		typing in the date directly does not work - which is needed (live dates aren't necessarily on week start)					
faj.v64.n3.15	9/14/2008	"=HLOOKUP($B23, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A23, table_64[[#All],[DOI]], 0), TRUE)"	"=HLOOKUP($B23+E$19, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A23, table_64[[#All],[DOI]], 0), TRUE)"							
faj.v64.n4.5	9/21/2008	"=HLOOKUP($B24, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A24, table_64[[#All],[DOI]], 0), TRUE)"	"=HLOOKUP($B24+E$19, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A24, table_64[[#All],[DOI]], 0), TRUE)"		Dates in table_64 came in from a csv file as 31-Aug-08 and were then corrected with error checking to show 4 digit year					
faj.v64.n5.6	9/28/2008	"=HLOOKUP($B25, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A25, table_64[[#All],[DOI]], 0), TRUE)"	"=HLOOKUP($B25+E$19, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A25, table_64[[#All],[DOI]], 0), TRUE)"		"I've tried reformatting the dates, adding zero to them, using datevalue and pasting the value back in"					
faj.v64.n6.9	10/5/2008	"=HLOOKUP($B26, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A26, table_64[[#All],[DOI]], 0), TRUE)"	"=HLOOKUP($B26+E$19, table_64[[#All],[DOI]:[10/12/2008]], MATCH($A26, table_64[[#All],[DOI]], 0), TRUE)"							
					I even tried copying the data out of the table and retyping the headers by hand for a whole new set of issues