Spreadsheet: 752449d1634757979-combining-lookup-and-match-i-think-formula-sample
Sheet: Sheet1

Date Sub |  | Start Date | End Date | Value
2021-01-05 00:00:00 |  |  | 2021-01-09 00:00:00 | Week 1
2021-01-05 00:00:00 |  |  | 2021-01-16 00:00:00 | Week 2
2021-01-05 00:00:00 |  |  | 2021-01-23 00:00:00 | Week 3
2021-01-05 00:00:00 |  |  | 2021-01-30 00:00:00 | Week 4
2021-01-06 00:00:00 |  |  | 2021-02-06 00:00:00 | Week 5
2021-01-08 00:00:00 |  |  | 2021-02-13 00:00:00 | Week 6
2021-01-08 00:00:00 |  |  | 2021-02-20 00:00:00 | Week 7
2021-01-11 00:00:00 |  |  | 2021-02-27 00:00:00 | Week 8
2021-01-12 00:00:00 |  |  | 2021-03-06 00:00:00 | Week 9
2021-01-13 00:00:00 |  |  | 2021-03-13 00:00:00 | Week 10
2021-01-13 00:00:00 |  |  | 2021-03-20 00:00:00 | Week 11
2021-01-13 00:00:00 |  |  | 2021-03-27 00:00:00 | Week 12
2021-01-14 00:00:00 |  |  | 2021-04-03 00:00:00 | Week 13
2021-01-15 00:00:00 |  |  | 2021-04-10 00:00:00 | Week 14
2021-01-15 00:00:00 |  |  | 2021-04-17 00:00:00 | Week 15
2021-01-18 00:00:00 |  |  | 2021-04-24 00:00:00 | Week 16
2021-01-18 00:00:00 |  |  | 2021-05-01 00:00:00 | Week 17
2021-01-20 00:00:00 |  |  | 2021-05-08 00:00:00 | Week 18
2021-01-20 00:00:00 |  |  | 2021-05-15 00:00:00 | Week 19
2021-01-21 00:00:00 |  |  | 2021-05-22 00:00:00 | Week 20
2021-01-21 00:00:00 |  |  | 2021-05-29 00:00:00 | Week 21
2021-01-21 00:00:00 |  |  | 2021-06-05 00:00:00 | Week 22
2021-01-21 00:00:00 |  |  | 2021-06-12 00:00:00 | Week 23
2021-01-25 00:00:00 |  |  | 2021-06-19 00:00:00 | Week 24
2021-01-25 00:00:00 |  |  | 2021-06-26 00:00:00 | Week 25
2021-01-25 00:00:00 |  |  | 2021-07-03 00:00:00 | Week 26
2021-01-26 00:00:00 |  |  | 2021-07-10 00:00:00 | Week 27
2021-01-28 00:00:00 |  |  | 2021-07-17 00:00:00 | Week 28
2021-02-01 00:00:00 |  |  | 2021-07-24 00:00:00 | Week 29
2021-02-03 00:00:00 |  |  | 2021-07-31 00:00:00 | Week 30
2021-02-03 00:00:00 |  |  | 2021-08-07 00:00:00 | Week 31
2021-02-03 00:00:00 |  |  | 2021-08-14 00:00:00 | Week 32
2021-02-04 00:00:00 |  |  | 2021-08-21 00:00:00 | Week 33
2021-02-04 00:00:00 |  |  | 2021-08-28 00:00:00 | Week 34
2021-02-09 00:00:00 |  |  | 2021-09-04 00:00:00 | Week 35
2021-02-10 00:00:00 |  |  | 2021-09-11 00:00:00 | Week 36
2021-02-11 00:00:00 |  |  | 2021-09-18 00:00:00 | Week 37
2021-02-11 00:00:00 |  |  | 2021-09-25 00:00:00 | Week 38
2021-02-11 00:00:00 |  |  | 2021-10-02 00:00:00 | Week 39
2021-02-11 00:00:00 |  |  | 2021-10-09 00:00:00 | Week 40
2021-02-11 00:00:00 |  |  | 2021-10-16 00:00:00 | Week 41
2021-02-11 00:00:00 |  |  | 2021-10-23 00:00:00 | Week 42
2021-02-11 00:00:00 |  |  | 2021-10-30 00:00:00 | Week 43
2021-02-12 00:00:00 |  |  | 2021-11-06 00:00:00 | Week 44
2021-02-12 00:00:00 |  |  | 2021-11-13 00:00:00 | Week 45
2021-02-12 00:00:00 |  |  | 2021-11-20 00:00:00 | Week 46
2021-02-12 00:00:00 |  |  | 2021-11-27 00:00:00 | Week 47
2021-02-12 00:00:00 |  |  | 2021-12-04 00:00:00 | Week 48
 |  |  | 2021-12-11 00:00:00 | Week 49
2021-02-15 00:00:00 |  |  | 2021-12-18 00:00:00 | Week 50
2021-02-15 00:00:00
2021-02-15 00:00:00
2021-02-15 00:00:00
2021-02-16 00:00:00
2021-02-16 00:00:00
2021-02-17 00:00:00
2021-02-17 00:00:00
2021-02-17 00:00:00
2021-02-17 00:00:00
2021-02-17 00:00:00
2021-02-17 00:00:00
2021-02-18 00:00:00
2021-02-18 00:00:00
2021-02-18 00:00:00
2021-02-19 00:00:00
2021-02-23 00:00:00
2021-02-23 00:00:00
2021-02-24 00:00:00
2021-02-24 00:00:00
2021-02-24 00:00:00
2021-02-24 00:00:00
2021-02-26 00:00:00
2021-03-02 00:00:00
2021-03-02 00:00:00
2021-03-03 00:00:00
2021-03-03 00:00:00
2021-03-04 00:00:00
2021-03-05 00:00:00
2021-03-05 00:00:00
2021-03-08 00:00:00
2021-03-09 00:00:00
2021-03-10 00:00:00
2021-03-10 00:00:00
2021-03-11 00:00:00
2021-03-15 00:00:00
2021-03-15 00:00:00
2021-03-15 00:00:00
2021-03-16 00:00:00
2021-03-16 00:00:00
2021-03-17 00:00:00
2021-03-17 00:00:00
2021-03-19 00:00:00
2021-03-23 00:00:00
2021-03-23 00:00:00
2021-03-25 00:00:00
2021-03-25 00:00:00
2021-03-25 00:00:00
2021-03-29 00:00:00
2021-03-29 00:00:00
2021-03-29 00:00:00
2021-03-30 00:00:00
2021-03-30 00:00:00
2021-03-31 00:00:00
2021-03-31 00:00:00
2021-04-01 00:00:00
2021-04-01 00:00:00
2021-04-02 00:00:00
2021-04-02 00:00:00
2021-04-02 00:00:00
2021-04-02 00:00:00
2021-04-15 00:00:00
2021-04-15 00:00:00
2021-04-15 00:00:00
2021-04-16 00:00:00
2021-04-20 00:00:00
2021-04-20 00:00:00
2021-04-20 00:00:00
2021-04-21 00:00:00
2021-04-22 00:00:00
2021-04-22 00:00:00
2021-04-22 00:00:00
2021-04-23 00:00:00
2021-04-23 00:00:00
2021-04-26 00:00:00
2021-04-27 00:00:00
2021-04-27 00:00:00
2021-04-28 00:00:00
2021-04-28 00:00:00
2021-04-28 00:00:00
2021-04-29 00:00:00
2021-04-29 00:00:00
2021-04-29 00:00:00
2021-04-29 00:00:00
2021-04-30 00:00:00
2021-04-30 00:00:00
2021-04-30 00:00:00
2021-04-30 00:00:00
2021-05-03 00:00:00
2021-05-03 00:00:00
2021-05-04 00:00:00
2021-05-04 00:00:00
2021-05-06 00:00:00
2021-05-06 00:00:00
2021-05-06 00:00:00
2021-05-07 00:00:00
2021-05-10 00:00:00
2021-05-11 00:00:00
2021-05-11 00:00:00
2021-05-11 00:00:00
2021-05-13 00:00:00
2021-05-13 00:00:00
2021-05-13 00:00:00
2021-05-14 00:00:00
2021-05-18 00:00:00
2021-05-18 00:00:00
2021-05-18 00:00:00
2021-05-18 00:00:00
2021-05-19 00:00:00
2021-05-19 00:00:00
2021-05-20 00:00:00
2021-05-21 00:00:00
2021-05-24 00:00:00
2021-05-24 00:00:00
2021-05-24 00:00:00
2021-05-25 00:00:00
2021-05-25 00:00:00
2021-05-26 00:00:00
2021-05-26 00:00:00
2021-05-27 00:00:00
2021-05-28 00:00:00
2021-05-28 00:00:00
2021-06-01 00:00:00
2021-06-01 00:00:00
2021-06-02 00:00:00
2021-06-02 00:00:00
2021-06-03 00:00:00
2021-06-07 00:00:00
2021-06-07 00:00:00
2021-06-09 00:00:00
2021-06-11 00:00:00
2021-06-11 00:00:00
2021-06-14 00:00:00
2021-06-14 00:00:00
2021-06-15 00:00:00
2021-06-15 00:00:00
2021-06-15 00:00:00
2021-06-17 00:00:00
2021-06-17 00:00:00
2021-06-21 00:00:00
2021-06-22 00:00:00
2021-06-22 00:00:00
2021-06-23 00:00:00
2021-06-28 00:00:00
2021-06-29 00:00:00
2021-06-29 00:00:00
2021-06-29 00:00:00
2021-06-29 00:00:00
2021-06-30 00:00:00
2021-07-01 00:00:00
2021-07-02 00:00:00
2021-07-02 00:00:00
2021-07-02 00:00:00
2021-07-02 00:00:00
2021-07-07 00:00:00
2021-07-07 00:00:00
2021-07-09 00:00:00
2021-07-09 00:00:00
2021-07-09 00:00:00
2021-07-09 00:00:00
2021-07-12 00:00:00
2021-07-12 00:00:00
2021-07-12 00:00:00
2021-07-12 00:00:00
2021-07-12 00:00:00
2021-07-12 00:00:00
2021-07-13 00:00:00
2021-07-14 00:00:00
2021-07-14 00:00:00
2021-07-16 00:00:00
2021-07-16 00:00:00
2021-07-19 00:00:00
2021-07-19 00:00:00
2021-07-20 00:00:00
2021-07-20 00:00:00
2021-07-22 00:00:00
2021-07-23 00:00:00
2021-07-23 00:00:00
2021-07-23 00:00:00
2021-07-26 00:00:00
2021-07-26 00:00:00
2021-07-27 00:00:00
2021-07-27 00:00:00
2021-07-27 00:00:00
2021-07-27 00:00:00
2021-07-28 00:00:00
2021-07-28 00:00:00
2021-07-28 00:00:00
2021-07-28 00:00:00
2021-07-28 00:00:00
2021-07-29 00:00:00
2021-07-30 00:00:00
2021-07-30 00:00:00
2021-08-02 00:00:00
2021-08-04 00:00:00
2021-08-04 00:00:00
2021-08-04 00:00:00
2021-08-04 00:00:00
2021-08-09 00:00:00
2021-08-09 00:00:00
2021-08-09 00:00:00
2021-08-10 00:00:00
2021-08-10 00:00:00
2021-08-11 00:00:00
2021-08-12 00:00:00
2021-08-12 00:00:00
2021-08-13 00:00:00
2021-08-16 00:00:00
2021-08-17 00:00:00
2021-08-17 00:00:00
2021-08-19 00:00:00
2021-08-23 00:00:00
2021-08-23 00:00:00
2021-08-23 00:00:00
2021-08-24 00:00:00
2021-08-25 00:00:00
2021-08-26 00:00:00
2021-08-26 00:00:00
2021-08-26 00:00:00
2021-08-27 00:00:00
2021-08-29 00:00:00
2021-08-30 00:00:00
2021-08-31 00:00:00
2021-09-02 00:00:00
2021-09-02 00:00:00
2021-09-07 00:00:00
2021-09-07 00:00:00
2021-09-08 00:00:00
2021-09-08 00:00:00
2021-09-09 00:00:00
2021-09-13 00:00:00
2021-09-14 00:00:00
2021-09-15 00:00:00
2021-09-15 00:00:00
2021-09-16 00:00:00
2021-09-17 00:00:00
2021-09-17 00:00:00
2021-09-17 00:00:00
2021-09-17 00:00:00
2021-09-22 00:00:00
2021-09-22 00:00:00
2021-09-22 00:00:00
2021-09-24 00:00:00
2021-09-28 00:00:00
2021-09-29 00:00:00
2021-09-29 00:00:00
2021-09-30 00:00:00
2021-09-30 00:00:00
2021-10-01 00:00:00
2021-10-01 00:00:00
2021-10-04 00:00:00
2021-10-06 00:00:00
2021-10-06 00:00:00
2021-10-06 00:00:00
2021-10-07 00:00:00
2021-10-07 00:00:00
2021-10-08 00:00:00
2021-10-11 00:00:00
2021-10-12 00:00:00
2021-10-13 00:00:00
2021-10-13 00:00:00
2021-10-14 00:00:00
2021-10-15 00:00:00
2021-10-15 00:00:00