Offset with nested if isnumber vlookup

[fatsbear]

Hi all,

I was trying to make this formula =IF(ISNUMBER(VLOOKUP(offset(D5B6,'In-day'!$B$6:$O$2881,COLUMN(A1),0)),offset(VLOOKUP(B6,'In-day'!$B$6:$O$2881,COLUMN(B1),0),""))) and put an offset function in there as well. below is my data. As you can see the source is daily and i want to make it weekly and if there is a blank then to put it as a Zero. This data goes from 2000-current. Thanks!

Where formula resides
07-Jan-2000 446.59
14-Jan-2000 433.77
21-Jan-2000 419.71
28-Jan-2000 435.09
04-Feb-2000 427.5
11-Feb-2000 0
18-Feb-2000 381.46
25-Feb-2000 388.99

Source Data
07-Jan-2000 446.59
08-Jan-2000
09-Jan-2000
10-Jan-2000
11-Jan-2000 448.41
12-Jan-2000 437.23
13-Jan-2000 435.47
14-Jan-2000 433.77
15-Jan-2000
16-Jan-2000
17-Jan-2000 432.99
18-Jan-2000 432.52
19-Jan-2000 429.46
20-Jan-2000 426.06
21-Jan-2000 419.71
22-Jan-2000
23-Jan-2000
24-Jan-2000 412.1
25-Jan-2000 407.85
26-Jan-2000 412.43
27-Jan-2000 425.03
28-Jan-2000 435.09
29-Jan-2000
30-Jan-2000
31-Jan-2000 433.49
01-Feb-2000 418.71
02-Feb-2000 427.77
03-Feb-2000 429.05
04-Feb-2000 427.5
05-Feb-2000
06-Feb-2000
07-Feb-2000 426.02
08-Feb-2000 412.18
09-Feb-2000 410.19
10-Feb-2000 402.87
11-Feb-2000
12-Feb-2000
13-Feb-2000
14-Feb-2000 387.96
15-Feb-2000 367.96
16-Feb-2000 381.95
17-Feb-2000 374.88
18-Feb-2000 381.46
19-Feb-2000
20-Feb-2000
21-Feb-2000 366.1
22-Feb-2000 365.09
23-Feb-2000 379.5
24-Feb-2000 379.11
25-Feb-2000 388.99
26-Feb-2000
27-Feb-2000
28-Feb-2000 386.71
29-Feb-2000 384.96
01-Mar-2000 387.14
02-Mar-2000 383.11
03-Mar-2000 378.73
04-Mar-2000
05-Mar-2000
06-Mar-2000 379.23
07-Mar-2000 382.8
08-Mar-2000 385.99
09-Mar-2000 404.41
10-Mar-2000 412.89
11-Mar-2000
12-Mar-2000
13-Mar-2000 420.05
14-Mar-2000 411.71
15-Mar-2000 401.92
16-Mar-2000 408.43
17-Mar-2000 414.17
18-Mar-2000
19-Mar-2000
20-Mar-2000
21-Mar-2000 411.66
22-Mar-2000 409.41
23-Mar-2000 403.02
24-Mar-2000 403.27
25-Mar-2000
26-Mar-2000
27-Mar-2000 411.18
28-Mar-2000 420.55
29-Mar-2000 432.78
30-Mar-2000 421.73
31-Mar-2000 427.27
01-Apr-2000
02-Apr-2000

 

[Robert Mika]

Hi,
Do you want to look for a specific day ,summarize by week or extract weekly data?.
From what you have presented(not sure if that is your desired result )it looks like you are just looking for a specific day.
What this part "D5B" of the offset do?