What I have:										
Issue	DOI	39691	39698	39705	39712	39719	39726	39733	Total	Rank
64_1	faj.v64.n1.12	11	15	1	3	1	0	1	=SUM(C3:I3)	9
64_2	faj.v64.n2.11	0	16	8	2	1	2	5	=SUM(C4:I4)	8
64_3	faj.v64.n3.15	0	0	12	7	2	4	2	=SUM(C5:I5)	7
64_4	faj.v64.n4.5	0	0	0	26	6	4	5	=SUM(C6:I6)	7
64_5	faj.v64.n5.6	0	0	0	0	27	15	33	=SUM(C7:I7)	6
64_6	faj.v64.n6.9	0	0	0	0	0	37	48	=SUM(C8:I8)	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	39691	"=HLOOKUP($B21, B2:I8, MATCH($A21, B2:B8, 0), TRUE)"	"=HLOOKUP($B21+E$19, 'With Table'!$B$2:$I$9, MATCH($A21, 'With Table'!$B$2:$B$9, 0), TRUE)"		Now copying the headers only works for the first one…					
faj.v64.n2.11	39698	"=HLOOKUP($B22, B3:I9, MATCH($A22, B3:B9, 0), TRUE)"	"=HLOOKUP($B22+E$19, 'With Table'!$B$2:$I$9, MATCH($A22, 'With Table'!$B$2:$B$9, 0), TRUE)"		This one is copied and pulling the last date column (10/12/2008)					
faj.v64.n3.15	39705	"=HLOOKUP($B23, B4:I10, MATCH($A23, B4:B10, 0), TRUE)"	"=HLOOKUP($B23+E$19, 'With Table'!$B$2:$I$9, MATCH($A23, 'With Table'!$B$2:$B$9, 0), TRUE)"		"This one is typed (after copy) and """""					
faj.v64.n4.5	9/21/2008	"=HLOOKUP($B24, B5:I11, MATCH($A24, B5:B11, 0), TRUE)"	"=HLOOKUP($B24+E$19, 'With Table'!$B$2:$I$9, MATCH($A24, 'With Table'!$B$2:$B$9, 0), TRUE)"		"This one is copied from the ""what I want"" table above -> original csv file date"					
faj.v64.n5.6	39690	"=HLOOKUP($B25, B6:I12, MATCH($A25, B6:B12, 0), TRUE)"	"=HLOOKUP($B25+E$19, 'With Table'!$B$2:$I$9, MATCH($A25, 'With Table'!$B$2:$B$9, 0), TRUE)"							
faj.v64.n6.9		"=HLOOKUP($B26, B7:I13, MATCH($A26, B7:B13, 0), TRUE)"	"=HLOOKUP($B26+E$19, 'With Table'!$B$2:$I$9, MATCH($A26, 'With Table'!$B$2:$B$9, 0), TRUE)"