Spreadsheet: 779752d1652084234-index-match-with-multiple-criteria-blanks-and-drop-down-lists-with-formula-index-match-multiple-criteria-aligw
Sheet: Sheet1

Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14
1 | Client 1 | Person H | 1 | [NAME] | Smith 1
2 | Client 2 | Person I | 2 | [NAME] | Smith 2 | 2022-02-21 11:00:00
3 | Client 3 | Person J | 3 | [NAME] | Smith 3
4 | Client 4 | Person D | 4 | [NAME] | Smith 4
5 | Client 5 | Person E | 5 | [NAME] | Smith 5 | 2022-02-21 11:00:00 | 2022-02-21 11:00:00
6 | Client 6 | Person F | 6 | [NAME] | Smith 6 | 2022-02-22 11:00:00 | 2022-03-01 14:27:46
7 | Client 7 | Person G | 7 | [NAME] | Smith 7 | 2022-02-22 11:00:00
8 | Client 8 | Person H | 8 | [NAME] | Smith 8 | 2022-02-22 11:00:00
9 | Client 9 | Person I | 9 | [NAME] | Smith 9 | 2022-02-22 11:00:00
10 | Client 10 | Person J | 10 | [NAME] 10 | Smith 10 | 2022-02-22 11:00:00 | 2022-02-23 11:00:00
11 | Client 11 | Person A | 11 | [NAME] | Smith 11 | 2022-02-22 11:00:00 | 2022-02-28 14:43:44 | 2022-03-09 09:48:20
12 | Client 12 | Person B | 12 | [NAME] | Smith 12 | 2022-02-23 11:00:00 | 2022-03-01 15:13:27
13 | Client 13 | Person C | 13 | [NAME] | Smith 13 | 2022-02-23 11:00:00 | 2022-02-25 11:00:00
14 | Client 14 | Person D | 14 | [NAME] | Smith 14 | 2022-02-23 11:00:00
15 | Client 15 | Person E | 15 | [NAME] 15 | Smith 15 | 2022-02-23 11:00:00
16 | Client 16 | Person F | 16 | [NAME] | Smith 16 | 2022-02-23 11:00:00
17 | Client 17 | Person G | 17 | [NAME] | Smith 17 | 2022-02-23 11:00:00 | 2022-02-23 11:00:00
18 | Client 18 | Person H | 18 | [NAME] | Smith 18 | 2022-02-23 11:00:00 | 2022-02-23 11:00:00
19 | Client 19 | Person I | 19 | [NAME] | Smith 19 | 2022-02-23 11:00:00 | 2022-03-17 16:24:51 | 2022-03-18 13:40:58 |  | 2022-04-01 14:08:14
20 | Client 20 | Person K | 20 | [NAME] 20 | Smith 20 | 2022-02-23 11:00:00 | 2022-02-23 11:00:00
21 | Client 21 | Person K | 21 | [NAME] 21 | Smith 21 | 2022-02-23 11:00:00 | 2022-03-01 09:51:24
22 | Client 22 | Person L | 22 | [NAME] | Smith 22 | 2022-02-24 11:00:00 | 2022-02-24 11:00:00
23 | Client 23 | Person A | 23 | [NAME] 23 | Smith 23 | 2022-02-24 11:00:00
24 | Client 24 | Person D | 24 | [NAME] | Smith 24 | 2022-02-24 11:00:00
25 | Client 25 | Person E | 25 | [NAME] | Smith 25 | 2022-02-24 11:00:00
26 | Client 26 | Person F | 26 | [NAME] 26 | Smith 26 | 2022-02-24 11:00:00
27 | Client 27 | Person G | 27 | [NAME] | Smith 27 | 2022-02-24 11:00:00 | 2022-03-09 09:26:48
28 | Client 28 | Person H | 28 | [NAME] | Smith 28 | 2022-02-24 11:00:00 | 2022-03-08 11:16:40
29 | Client 29 | Person I | 29 | [NAME] 29 | Smith 29 | 2022-02-24 11:00:00 |  | 2022-03-11 16:36:18 |  | 2022-03-31 23:39:47
30 | Client 30 | Person J | 30 | [NAME] 30 | Smith 30 | 2022-02-24 11:00:00
31 | Client 31 | Person J | 31 | [NAME] | Smith 31 | 2022-02-25 11:00:00 | 2022-03-01 14:27:56
32 | Client 32 | Person K | 32 | [NAME] 32 | Smith 32 | 2022-02-25 11:00:00 |  | 2022-03-07 19:29:09 |  | 2022-03-28 11:36:11
33 | Client 33 | Person L | 33 | [NAME] | Smith 33 | 2022-02-25 11:00:00 | 2022-03-07 14:44:32 | 2022-03-08 13:31:22 |  | 2022-03-24 10:42:22
34 | Client 34 | Person A | 34 | [NAME] 34 | Smith 34 | 2022-02-27 11:00:00
35 | Client 35 | Person J | 35 | [NAME] | Smith 35 | 2022-02-28 11:00:00 | 2022-03-21 09:38:55
36 | Client 36 | Person K | 36 | [NAME] 36 | Smith 36 | 2022-02-28 11:00:00
37 | Client 37 | Person L | 37 | [NAME] | Smith 37 | 2022-02-28 11:00:00 | 2022-03-07 10:28:37
38 | Client 38 | Person H | 38 | [NAME] 38 | Smith 38 | 2022-02-28 11:00:00
39 | Client 39 | Person I | 39 | [NAME] | Smith 39 | 2022-02-28 16:10:26 | 2022-03-09 10:58:09 | 2022-03-14 19:09:30 |  | 2022-03-16 10:52:07 | 2022-03-31 15:50:20
40 | Client 40 | Person K | 40 | [NAME] | Smith 40 | 2022-03-01 10:43:21 | 2022-04-06 09:06:57 | 2022-04-06 09:09:37
41 | Client 41 | Person L | 41 | [NAME] | Smith 41 | 2022-03-01 10:57:30 | 2022-03-04 11:54:53 | 2022-03-25 09:13:36 |  | 2022-04-05 16:32:33
42 | Client 42 | Person A | 42 | [NAME] | Smith 42 | 2022-03-01 11:10:41 | 2022-03-08 15:02:49
43 | Client 43 | Person B | 43 | [NAME] | Smith 43 | 2022-03-01 11:54:45 | 2022-03-30 19:26:13
44 | Client 44 | Person C | 44 | [NAME] | Smith 44 | 2022-03-01 12:06:10
45 | Client 45 | Person D | 45 | [NAME] | Smith 45 | 2022-03-01 12:24:47 | 2022-03-04 11:54:47 | 2022-04-04 13:58:59 | 2022-04-05 16:51:35
46 | Client 46 | Person E | 46 | [NAME] | Smith 46 | 2022-03-01 13:56:31
47 | Client 47 | Person F | 47 | [NAME] | Smith 47 | 2022-03-01 15:18:07 | 2022-04-05 07:21:13
48 | Client 48 | Person G | 48 | [NAME] | Smith 48 | 2022-03-01 15:39:40
49 | Client 49 | Person H | 49 | [NAME] | Smith 49 | 2022-03-01 16:54:26 | 2022-03-09 07:15:39
50 | Client 50 | Person H | 50 | [NAME] 50 | Smith 50 | 2022-03-01 17:12:41
51 | Client 51 | Person I | 51 | [NAME] | Smith 51 | 2022-03-01 21:31:20 | 2022-03-01 22:06:55 | 2022-03-25 14:35:00
52 | Client 52 | Person J | 52 | [NAME] 52 | Smith 52 | 2022-03-02 09:25:46
53 | Client 53 | Person J | 53 | [NAME] 53 | Smith 53 | 2022-03-02 09:34:59
54 | Client 54 | Person A | 54 | [NAME] | Smith 54 | 2022-03-02 12:14:31 | 2022-04-05 07:22:12
55 | Client 55 | Person I | 55 | [NAME] 55 | Smith 55 | 2022-03-02 15:25:39 | 2022-03-10 09:45:56
56 | Client 56 | Person J | 56 | [NAME] | Smith 56 | 2022-03-03 09:46:38
57 | Client 57 | Person K | 57 | [NAME] | Smith 57 | 2022-03-03 10:07:44 |  | 2022-03-17 13:17:49
58 | Client 58 | Person L | 58 | [NAME] | Smith 58 | 2022-03-03 10:57:14 | 2022-03-09 13:27:42
59 | Client 59 | Person H | 59 | [NAME] | Smith 59 | 2022-03-03 11:03:54 | 2022-03-10 09:45:36
60 | Client 60 | Person I | 60 | [NAME] 60 | Smith 60 | 2022-03-03 12:55:44
61 | Client 61 | Person J | 61 | [NAME] | Smith 61 | 2022-03-03 16:44:31 | 2022-03-10 09:45:45
62 | Client 62 | Person A | 62 | [NAME] 62 | Smith 62 | 2022-03-04 11:07:29 | 2022-03-04 11:09:33 | 2022-03-15 15:28:15 |  | 2022-03-31 15:28:07
63 | Client 63 | Person B | 63 | [NAME] | Smith 63 | 2022-03-04 12:59:46 |  | 2022-04-05 11:50:00
64 | Client 64 | Person C | 64 | [NAME] | Smith 64 | 2022-03-07 09:13:50 |  | 2022-03-10 16:39:49 |  | 2022-03-18 13:41:16 | 2022-03-22 13:31:30
65 | Client 65 | Person D | 65 | [NAME] 65 | Smith 65 | 2022-03-07 10:04:12
66 | Client 66 | Person E | 66 | [NAME] | Smith 66 | 2022-03-07 10:18:45
67 | Client 67 | Person F | 67 | [NAME] | Smith 67 | 2022-03-07 11:06:18
68 | Client 68 | Person G | 68 | [NAME] | Smith 68 | 2022-03-07 11:54:34
69 | Client 69 | Person H | 69 | [NAME] | Smith 69 | 2022-03-07 16:24:03
70 | Client 70 | Person H | 70 | [NAME] 70 | Smith 70 | 2022-03-08 15:25:10 | 2022-03-17 10:58:29 | 2022-03-17 12:49:49
71 | Client 71 | Person I | 71 | [NAME] | Smith 71 | 2022-03-09 10:17:41
72 | Client 72 | Person J | 72 | [NAME] | Smith 72 | 2022-03-09 10:36:13
73 | Client 73 | Person J | 73 | [NAME] 73 | Smith 73 | 2022-03-09 10:42:19
74 | Client 74 | Person A | 74 | [NAME] 74 | Smith 74 | 2022-03-09 14:13:36
75 | Client 75 | Person I | 75 | [NAME] 75 | Smith 75 | 2022-03-09 17:16:53 |  | 2022-03-11 16:50:43 |  | 2022-04-04 15:16:08
76 | Client 76 | Person J | 76 | [NAME] | Smith 76 | 2022-03-10 09:45:43 | 2022-03-23 13:55:03 | 2022-04-04 17:02:23
77 | Client 77 | Person J | 77 | [NAME] | Smith 77 | 2022-03-10 10:17:39
78 | Client 78 | Person A | 78 | [NAME] 78 | Smith 78 | 2022-03-10 12:20:23 | 2022-03-23 13:57:02 | 2022-04-05 10:35:39 | 2022-04-05 10:35:24 | 2022-04-06 12:07:59
79 | Client 79 | Person I | 79 | [NAME] 79 | Smith 79 | 2022-03-10 12:48:20 | 2022-04-07 10:36:23
80 | Client 80 | Person J | 80 | [NAME] 80 | Smith 80 | 2022-03-10 14:26:26
81 | Client 81 | Person K | 81 | [NAME] | Smith 81 | 2022-03-10 15:33:54
82 | Client 82 | Person L | 82 | [NAME] | Smith 82 | 2022-03-11 08:47:23
83 | Client 83 | Person J | 83 | [NAME] | Smith 83 | 2022-03-11 15:27:42
84 | Client 84 | Person A | 84 | [NAME] | Smith 84 | 2022-03-14 14:46:04 | 2022-03-14 14:57:20
85 | Client 85 | Person J | 85 | [NAME] 85 | Smith 85 | 2022-03-15 10:37:50
86 | Client 86 | Person A | 86 | [NAME] | Smith 86 | 2022-03-15 15:36:20
87 | Client 87 | Person I | 87 | [NAME] | Smith 87 | 2022-03-15 15:47:11 |  | 2022-03-31 16:59:55 | 2022-04-04 14:46:12
88 | Client 88 | Person J | 88 | [NAME] | Smith 88 | 2022-03-15 15:56:32 | 2022-04-05 12:03:28
89 | Client 89 | Person J | 89 | [NAME] | Smith 89 | 2022-03-15 15:57:11 | 2022-03-18 12:04:41
90 | Client 90 | Person A | 90 | [NAME] | Smith 90 | 2022-03-16 09:48:49 | 2022-03-23 14:08:07
91 | Client 91 | Person I | 91 | [NAME] | Smith 91 | 2022-03-16 10:14:20
92 | Client 92 | Person J | 92 | [NAME] 92 | Smith 92 | 2022-03-16 11:17:20
93 | Client 93 | Person K | 93 | [NAME] 93 | Smith 93 | 2022-03-16 14:35:08 | 2022-03-18 12:04:55 | 2022-04-06 10:39:13
94 | Client 94 | Person L | 94 | [NAME] 94 | Smith 94 | 2022-03-16 15:10:37
95 | Client 95 | Person A | 95 | [NAME] | Smith 95 | 2022-03-17 09:47:01
96 | Client 96 | Person B | 96 | [NAME] 96 | Smith 96 | 2022-03-17 10:17:01
97 | Client 97 | Person C | 97 | [NAME] 97 | Smith 97 | 2022-03-17 10:40:17 | 2022-04-07 10:12:56
98 | Client 98 | Person D | 98 | [NAME] 98 | Smith 98 | 2022-03-17 11:58:07 |  | 2022-03-25 17:14:34 | 2022-03-28 09:30:00 | 2022-04-05 09:44:33
99 | Client 99 | Person E | 99 | [NAME] | Smith 99 | 2022-03-17 13:01:49 |  | 2022-03-28 15:34:28
100 | Client 100 | Person F | 100 | [NAME] 100 | Smith 100 | 2022-03-17 14:18:44 | 2022-04-05 16:19:14