Spreadsheet: 745830d1630283754-formula-not-finding-value-at-or-nearest-to-month-end-monthly-inventory
Sheet: CLOSING INVENTORY

Date | Product | Bought | Online | Retail | Sold | Inventory |  | CLOSING INVENTORY |  |  |  |  |  |  | CLOSING INVENTORY
2021-01-01 00:00:00 | Product 2 | 79 | 27 | 44 | 71 |  |  | MONTH | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 |  | MONTH | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
2021-01-02 00:00:00 | Product 3 | 85 | 12 | 10 | 22 |  |  | 2021-01-01 00:00:00 |  |  |  |  |  |  | 2021-01-01 00:00:00
2021-01-03 00:00:00 | Product 5 | 54 | 27 | 29 | 56 |  |  | 2021-02-01 00:00:00 |  |  |  |  |  |  | 2021-02-01 00:00:00
2021-01-04 00:00:00 | Product 5 | 86 | 6 | 14 | 20 |  |  | 2021-03-01 00:00:00 |  |  |  |  |  |  | 2021-03-01 00:00:00
2021-01-05 00:00:00 | Product 3 | 82 | 18 | 75 | 93 |  |  | 2021-04-01 00:00:00 |  |  |  |  |  |  | 2021-04-01 00:00:00
2021-01-06 00:00:00 | Product 1 | 45 | 29 | 44 | 73 |  |  | 2021-05-01 00:00:00 |  |  |  |  |  |  | 2021-05-01 00:00:00
2021-01-07 00:00:00 | Product 3 | 39 | 11 | 13 | 24 |  |  | 2021-06-01 00:00:00 |  |  |  |  |  |  | 2021-06-01 00:00:00
2021-01-08 00:00:00 | Product 4 | 39 | 9 | 48 | 57 |  |  |  |  |  |  |  |  |  |  | S/be
2021-01-09 00:00:00 | Product 1 | 96 | 18 | 65 | 83
2021-01-10 00:00:00 | Product 4 | 54 | 27 | 31 | 58
2021-01-11 00:00:00 | Product 5 | 70 | 15 | 21 | 36
2021-01-12 00:00:00 | Product 5 | 45 | 27 | 72 | 99
2021-01-13 00:00:00 | Product 3 | 79 | 45 | 54 | 99
2021-01-14 00:00:00 | Product 2 | 83 | 21 | 21 | 42
2021-01-15 00:00:00 | Product 4 | 28 | 12 | 52 | 64
2021-01-16 00:00:00 | Product 5 | 36 | 14 | 56 | 70
2021-01-17 00:00:00 | Product 3 | 44 | 18 | 35 | 53
2021-01-18 00:00:00 | Product 2 | 51 | 31 | 67 | 98
2021-01-19 00:00:00 | Product 1 | 82 | 6 | 9 | 15
2021-01-20 00:00:00 | Product 1 | 95 | 4 | 13 | 17
2021-01-21 00:00:00 | Product 1 | 76 | 29 | 52 | 81
2021-01-22 00:00:00 | Product 1 | 36 | 11 | 11 | 22
2021-01-23 00:00:00 | Product 4 | 21 | 6 | 30 | 36
2021-01-24 00:00:00 | Product 5 | 83 | 47 | 50 | 97
2021-01-25 00:00:00 | Product 2 | 52 | 14 | 15 | 29
2021-01-26 00:00:00 | Product 5 | 49 | 9 | 25 | 34
2021-01-27 00:00:00 | Product 1 | 74 | 36 | 40 | 76
2021-01-28 00:00:00 | Product 4 | 11 | 7 | 6 | 13
2021-01-29 00:00:00 | Product 3 | 75 | 19 | 29 | 48
2021-01-30 00:00:00 | Product 4 | 36 | 21 | 66 | 87
2021-01-31 00:00:00 | Product 2 | 36 | 4 | 13 | 17
2021-02-01 00:00:00 | Product 5 | 85 | 32 | 60 | 92
2021-02-02 00:00:00 | Product 1 | 45 | 7 | 15 | 22
2021-02-03 00:00:00 | Product 1 | 30 | 26 | 37 | 63
2021-02-04 00:00:00 | Product 4 | 90 | 4 | 23 | 27
2021-02-05 00:00:00 | Product 4 | 97 | 15 | 32 | 47
2021-02-06 00:00:00 | Product 1 | 57 | 19 | 17 | 36
2021-02-07 00:00:00 | Product 4 | 58 | 31 | 38 | 69
2021-02-08 00:00:00 | Product 3 | 38 | 31 | 39 | 70
2021-02-09 00:00:00 | Product 4 | 92 | 6 | 10 | 16
2021-02-10 00:00:00 | Product 2 | 84 | 27 | 32 | 59
2021-02-11 00:00:00 | Product 3 | 15 | 20 | 55 | 75
2021-02-12 00:00:00 | Product 2 | 95 | 19 | 37 | 56
2021-02-13 00:00:00 | Product 2 | 52 | 14 | 12 | 26
2021-02-14 00:00:00 | Product 5 | 63 | 3 | 12 | 15
2021-02-15 00:00:00 | Product 5 | 28 | 21 | 46 | 67
2021-02-16 00:00:00 | Product 4 | 13 | 26 | 23 | 49
2021-02-17 00:00:00 | Product 4 | 10 | 7 | 23 | 30
2021-02-18 00:00:00 | Product 1 | 19 | 19 | 17 | 36
2021-02-19 00:00:00 | Product 4 | 17 | 8 | 7 | 15
2021-02-20 00:00:00 | Product 4 | 44 | 19 | 36 | 55
2021-02-21 00:00:00 | Product 5 | 15 | 14 | 82 | 96
2021-02-22 00:00:00 | Product 2 | 47 | 4 | 13 | 17
2021-02-23 00:00:00 | Product 3 | 79 | 13 | 18 | 31
2021-02-24 00:00:00 | Product 2 | 68 | 38 | 32 | 70
2021-02-25 00:00:00 | Product 1 | 42 | 25 | 60 | 85
2021-02-26 00:00:00 | Product 3 | 66 | 6 | 11 | 17
2021-02-27 00:00:00 | Product 3 | 69 | 46 | 43 | 89
2021-02-28 00:00:00 | Product 3 | 63 | 19 | 47 | 66
2021-03-01 00:00:00 | Product 3 | 88 | 17 | 45 | 62
2021-03-02 00:00:00 | Product 2 | 45 | 35 | 28 | 63
2021-03-03 00:00:00 | Product 4 | 95 | 8 | 17 | 25
2021-03-04 00:00:00 | Product 5 | 44 | 17 | 16 | 33
2021-03-05 00:00:00 | Product 5 | 39 | 5 | 10 | 15
2021-03-06 00:00:00 | Product 4 | 30 | 14 | 42 | 56
2021-03-07 00:00:00 | Product 1 | 20 | 18 | 62 | 80
2021-03-08 00:00:00 | Product 5 | 23 | 14 | 40 | 54
2021-03-09 00:00:00 | Product 5 | 61 | 29 | 42 | 71
2021-03-10 00:00:00 | Product 3 | 58 | 17 | 64 | 81
2021-03-11 00:00:00 | Product 4 | 60 | 11 | 55 | 66
2021-03-12 00:00:00 | Product 1 | 94 | 8 | 34 | 42
2021-03-13 00:00:00 | Product 5 | 87 | 36 | 60 | 96
2021-03-14 00:00:00 | Product 1 | 78 | 18 | 71 | 89
2021-03-15 00:00:00 | Product 4 | 54 | 6 | 11 | 17
2021-03-16 00:00:00 | Product 5 | 59 | 18 | 36 | 54
2021-03-17 00:00:00 | Product 1 | 72 | 6 | 14 | 20
2021-03-18 00:00:00 | Product 5 | 77 | 2 | 11 | 13
2021-03-19 00:00:00 | Product 1 | 18 | 6 | 19 | 25
2021-03-20 00:00:00 | Product 2 | 13 | 30 | 35 | 65
2021-03-21 00:00:00 | Product 2 | 51 | 8 | 11 | 19
2021-03-22 00:00:00 | Product 3 | 58 | 20 | 75 | 95
2021-03-23 00:00:00 | Product 4 | 14 | 10 | 36 | 46
2021-03-24 00:00:00 | Product 3 | 75 | 36 | 34 | 70
2021-03-25 00:00:00 | Product 2 | 53 | 41 | 40 | 81
2021-03-26 00:00:00 | Product 2 | 57 | 10 | 30 | 40
2021-03-27 00:00:00 | Product 3 | 94 | 46 | 50 | 96
2021-03-28 00:00:00 | Product 1 | 54 | 28 | 48 | 76
2021-03-29 00:00:00 | Product 1 | 64 | 7 | 41 | 48
2021-03-30 00:00:00 | Product 1 | 48 | 8 | 34 | 42
2021-03-31 00:00:00 | Product 4 | 38 | 21 | 20 | 41
2021-04-01 00:00:00 | Product 3 | 69 | 41 | 56 | 97
2021-04-02 00:00:00 | Product 4 | 86 | 24 | 54 | 78
2021-04-03 00:00:00 | Product 5 | 87 | 4 | 9 | 13
2021-04-04 00:00:00 | Product 4 | 46 | 13 | 11 | 24
2021-04-05 00:00:00 | Product 5 | 64 | 16 | 16 | 32
2021-04-06 00:00:00 | Product 1 | 32 | 8 | 27 | 35
2021-04-07 00:00:00 | Product 2 | 55 | 4 | 7 | 11
2021-04-08 00:00:00 | Product 3 | 70 | 6 | 30 | 36
2021-04-09 00:00:00 | Product 2 | 40 | 38 | 37 | 75
2021-04-10 00:00:00 | Product 2 | 77 | 31 | 65 | 96
2021-04-11 00:00:00 | Product 1 | 97 | 6 | 15 | 21
2021-04-12 00:00:00 | Product 3 | 70 | 45 | 53 | 98
2021-04-13 00:00:00 | Product 2 | 76 | 25 | 24 | 49
2021-04-14 00:00:00 | Product 3 | 37 | 23 | 73 | 96
2021-04-15 00:00:00 | Product 3 | 55 | 11 | 21 | 32
2021-04-16 00:00:00 | Product 3 | 35 | 33 | 44 | 77
2021-04-17 00:00:00 | Product 1 | 74 | 15 | 25 | 40
2021-04-18 00:00:00 | Product 2 | 56 | 23 | 34 | 57
2021-04-19 00:00:00 | Product 5 | 65 | 20 | 22 | 42
2021-04-20 00:00:00 | Product 2 | 79 | 12 | 17 | 29
2021-04-21 00:00:00 | Product 4 | 96 | 10 | 32 | 42
2021-04-22 00:00:00 | Product 1 | 36 | 46 | 40 | 86
2021-04-23 00:00:00 | Product 5 | 84 | 42 | 42 | 84
2021-04-24 00:00:00 | Product 2 | 89 | 9 | 13 | 22
2021-04-25 00:00:00 | Product 4 | 46 | 8 | 21 | 29
2021-04-26 00:00:00 | Product 4 | 99 | 14 | 21 | 35
2021-04-27 00:00:00 | Product 1 | 74 | 40 | 41 | 81
2021-04-28 00:00:00 | Product 4 | 59 | 33 | 60 | 93
2021-04-29 00:00:00 | Product 2 | 84 | 5 | 15 | 20
2021-04-30 00:00:00 | Product 3 | 52 | 23 | 51 | 74
2021-05-01 00:00:00 | Product 4 | 78 | 35 | 54 | 89
2021-05-02 00:00:00 | Product 5 | 10 | 16 | 34 | 50
2021-05-03 00:00:00 | Product 5 | 55 | 14 | 16 | 30
2021-05-04 00:00:00 | Product 5 | 68 | 15 | 24 | 39
2021-05-05 00:00:00 | Product 2 | 65 | 23 | 19 | 42
2021-05-06 00:00:00 | Product 4 | 33 | 24 | 65 | 89
2021-05-07 00:00:00 | Product 2 | 45 | 6 | 25 | 31
2021-05-08 00:00:00 | Product 4 | 54 | 8 | 12 | 20
2021-05-09 00:00:00 | Product 1 | 88 | 43 | 55 | 98
2021-05-10 00:00:00 | Product 4 | 23 | 18 | 28 | 46
2021-05-11 00:00:00 | Product 4 | 23 | 25 | 25 | 50
2021-05-12 00:00:00 | Product 2 | 31 | 7 | 19 | 26
2021-05-13 00:00:00 | Product 1 | 40 | 4 | 24 | 28
2021-05-14 00:00:00 | Product 2 | 82 | 28 | 52 | 80
2021-05-15 00:00:00 | Product 2 | 38 | 8 | 47 | 55
2021-05-16 00:00:00 | Product 5 | 83 | 13 | 50 | 63
2021-05-17 00:00:00 | Product 4 | 32 | 19 | 64 | 83
2021-05-18 00:00:00 | Product 3 | 71 | 17 | 32 | 49
2021-05-19 00:00:00 | Product 2 | 98 | 17 | 27 | 44
2021-05-20 00:00:00 | Product 4 | 59 | 38 | 48 | 86
2021-05-21 00:00:00 | Product 5 | 52 | 2 | 10 | 12
2021-05-22 00:00:00 | Product 4 | 95 | 17 | 19 | 36
2021-05-23 00:00:00 | Product 2 | 79 | 29 | 46 | 75
2021-05-24 00:00:00 | Product 1 | 14 | 43 | 39 | 82
2021-05-25 00:00:00 | Product 4 | 92 | 13 | 40 | 53
2021-05-26 00:00:00 | Product 1 | 55 | 23 | 31 | 54
2021-05-27 00:00:00 | Product 5 | 51 | 10 | 25 | 35
2021-05-28 00:00:00 | Product 1 | 83 | 13 | 25 | 38
2021-05-29 00:00:00 | Product 1 | 93 | 52 | 46 | 98
2021-05-30 00:00:00 | Product 4 | 45 | 16 | 44 | 60
2021-05-31 00:00:00 | Product 5 | 76 | 6 | 11 | 17
2021-06-01 00:00:00 | Product 3 | 88 | 13 | 12 | 25
2021-06-02 00:00:00 | Product 2 | 72 | 18 | 61 | 79
2021-06-03 00:00:00 | Product 1 | 38 | 18 | 15 | 33
2021-06-04 00:00:00 | Product 3 | 15 | 4 | 16 | 20
2021-06-05 00:00:00 | Product 2 | 18 | 18 | 23 | 41
2021-06-06 00:00:00 | Product 3 | 92 | 26 | 23 | 49
2021-06-07 00:00:00 | Product 5 | 16 | 14 | 40 | 54
2021-06-08 00:00:00 | Product 2 | 70 | 7 | 6 | 13
2021-06-09 00:00:00 | Product 4 | 30 | 24 | 60 | 84
2021-06-10 00:00:00 | Product 5 | 60 | 25 | 25 | 50
2021-06-11 00:00:00 | Product 5 | 57 | 14 | 36 | 50
2021-06-12 00:00:00 | Product 1 | 69 | 22 | 50 | 72
2021-06-13 00:00:00 | Product 3 | 94 | 18 | 16 | 34
2021-06-14 00:00:00 | Product 4 | 17 | 27 | 29 | 56
2021-06-15 00:00:00 | Product 1 | 15 | 34 | 31 | 65
2021-06-16 00:00:00 | Product 4 | 21 | 20 | 58 | 78
2021-06-17 00:00:00 | Product 4 | 94 | 28 | 56 | 84
2021-06-18 00:00:00 | Product 4 | 31 | 22 | 22 | 44
2021-06-19 00:00:00 | Product 1 | 12 | 16 | 33 | 49
2021-06-20 00:00:00 | Product 2 | 84 | 25 | 33 | 58
2021-06-21 00:00:00 | Product 3 | 64 | 8 | 17 | 25
2021-06-22 00:00:00 | Product 5 | 19 | 26 | 23 | 49
2021-06-23 00:00:00 | Product 1 | 96 | 6 | 9 | 15
2021-06-24 00:00:00 | Product 5 | 61 | 23 | 67 | 90
2021-06-25 00:00:00 | Product 3 | 70 | 25 | 40 | 65
2021-06-26 00:00:00 | Product 5 | 76 | 19 | 39 | 58
2021-06-27 00:00:00 | Product 1 | 28 | 21 | 25 | 46
2021-06-28 00:00:00 | Product 4 | 44 | 24 | 30 | 54
2021-06-29 00:00:00 | Product 1 | 20 | 13 | 27 | 40
2021-06-30 00:00:00 | Product 3 | 10 | 13 | 53 | 66