Thread: Lookup Values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Lookup Values

Harlan wrote...
The weeks, 1-4 are in row 2 in the Weekly Worksheet. *So yes, there are 4
columns for the weeks, going from C2:BF2. . . .


C2:BF2 is 56 columns. If there are 4 weeks per period, then there'd be
56/4 = 14 periods. You had said previously there were 13 periods. I
can see how having weeks begin on Sunday or Monday and years beginning
on 1 Jan and ending on 31 Dec you could have 53 weeks, but I'm at a
loss to figure out how you have 56 weeks.

. . . What I don't understand in your formula are the curly brackets. . .