Spreadsheet: 810674d1671953265-how-to-use-variable-lookup_array-with-xmatch-formula-xmatch-student_name-b-3-b216-0-1-student-marks
Sheet: Visit Records

Student All Marks Record |  |  |  |  | Student Name |  | Last 3 Test Marks |  |  |  | Error in Row |  |  |  | Correct but manual
S. No | Student Name | Marks | Test Date |  |  |  | 3 | 2 | 1 |  | 3 | 2 | 1 |  | 3 | 2 | 1 |  |  |  |  |  | Latest Marks
1 | Anoj | 57 | 2019-04-12 00:00:00 |  | Anoj |  |  |  |  |  |  |  |  |  | 217 | 195 | 164
2 | [NAME] | 18 | 2019-04-16 00:00:00 |  | [NAME] |  |  |  |  |  | 216 | 196 | 165 |  | 216 | 196 | 165 |  |  |  | 196
3 | Manish | 83 | 2019-04-28 00:00:00 |  | Manish |  |  |  |  |  | 215 | 197 | 166 |  | 215 | 197 | 166 |  |  |  | 197
4 | Vinod | 46 | 2019-05-02 00:00:00 |  | Vinod |  |  |  |  |  | 214 | 214 | 167 |  | 214 | 167 | 148 |  |  |  | 214
5 | Iqbal | 28 | 2019-05-14 00:00:00 |  | Iqbal |  |  |  |  |  | 213 | 213 | 171 |  | 213 | 171 | 168 |  |  |  | 213
6 | [NAME] | 23 | 2019-05-18 00:00:00 |  | [NAME] |  |  |  |  |  | 212 | 212 | 172 |  | 212 | 172 | 169 |  |  |  | 212
7 | [NAME] | 29 | 2019-05-30 00:00:00 |  | [NAME] |  |  |  |  |  | 211 | 211 | 173 |  | 211 | 173 | 170 |  |  |  | 211
8 | [NAME] | 58 | 2019-06-03 00:00:00 |  | [NAME] |  |  |  |  |  | 210 | 210 | 174 |  | 210 | 174 | 152 |  |  |  | 210
9 | Rubi | 79 | 2019-06-15 00:00:00 |  | Rubi |  |  |  |  |  | 209 | 209 | 175 |  | 209 | 175 | 153 |  |  |  | 209
10 | [NAME] | 49 | 2019-06-19 00:00:00 |  | [NAME] |  |  |  |  |  | 208 | 208 | 176 |  | 208 | 176 | 154 |  |  |  | 208
11 | Rohan | 35 | 2019-07-01 00:00:00 |  | Rohan |  |  |  |  |  | 207 | 207 | 177 |  | 207 | 177 | 155 |  |  |  | 207
12 | Kuldeep | 10 | 2019-07-05 00:00:00 |  | Kuldeep |  |  |  |  |  | 206 | 206 | 186 |  | 206 | 186 | 178 |  |  |  | 206
13 | [NAME] | 20 | 2019-07-17 00:00:00 |  | [NAME] |  |  |  |  |  | 205 | 205 | 187 |  | 205 | 187 | 179 |  |  |  | 205
14 | [NAME] | 33 | 2019-07-21 00:00:00 |  | [NAME] |  |  |  |  |  | 204 | 204 | 188 |  | 204 | 188 | 180 |  |  |  | 204
15 | Vinit | 86 | 2019-08-02 00:00:00 |  | Vinit |  |  |  |  |  | 203 | 203 | 189 |  | 203 | 189 | 181 |  |  |  | 203
16 | Manoj | 75 | 2019-08-06 00:00:00 |  | Manoj |  |  |  |  |  | 202 | 202 | 190 |  | 202 | 190 | 182 |  |  |  | 202
17 | Vikram | 58 | 2019-08-18 00:00:00 |  | Vikram |  |  |  |  |  | 201 | 201 | 191 |  | 201 | 191 | 183 |  |  |  | 201
18 | Ravi | 38 | 2019-08-22 00:00:00 |  | Ravi |  |  |  |  |  | 200 | 200 | 192 |  | 200 | 192 | 184 |  |  |  | 200
19 | Ramaiya | 33 | 2019-09-03 00:00:00 |  | Ramaiya |  |  |  |  |  | 199 | 199 | 193 |  | 199 | 193 | 185 |  |  |  | 199
20 | Jupiter | 39 | 2019-09-07 00:00:00 |  | Jupiter |  |  |  |  |  | 198 | 198 | 194 |  | 198 | 194 | 144 |  |  |  | 198
21 | Rohan | 98 | 2019-09-19 00:00:00
22 | Kuldeep | 98 | 2019-09-23 00:00:00
23 | [NAME] | 66 | 2019-10-05 00:00:00
24 | [NAME] | 36 | 2019-10-09 00:00:00 |  |  |  |  |  |  |  | lookup_range should be changed from L column value
25 | Vinit | 84 | 2019-10-21 00:00:00
26 | Manoj | 76 | 2019-10-25 00:00:00
27 | Vikram | 53 | 2019-11-06 00:00:00
28 | Ravi | 42 | 2019-11-10 00:00:00
29 | Ramaiya | 75 | 2019-11-22 00:00:00
30 | Jupiter | 52 | 2019-11-26 00:00:00
31 | [NAME] | 71 | 2019-12-08 00:00:00
32 | [NAME] | 74 | 2019-12-12 00:00:00
33 | Rubi | 52 | 2019-12-24 00:00:00
34 | [NAME] | 33 | 2019-12-28 00:00:00
35 | Rohan | 52 | 2020-01-09 00:00:00
36 | Kuldeep | 96 | 2020-01-13 00:00:00
37 | [NAME] | 54 | 2020-01-25 00:00:00
38 | [NAME] | 42 | 2020-01-29 00:00:00
39 | Anoj | 44 | 2020-02-10 00:00:00
40 | [NAME] | 27 | 2020-02-14 00:00:00
41 | Manish | 59 | 2020-02-26 00:00:00
42 | Vinod | 43 | 2020-03-01 00:00:00
43 | Iqbal | 65 | 2020-03-13 00:00:00
44 | [NAME] | 36 | 2020-03-17 00:00:00
45 | [NAME] | 31 | 2020-03-29 00:00:00
46 | Iqbal | 65 | 2020-04-02 00:00:00
47 | [NAME] | 94 | 2020-04-14 00:00:00
48 | [NAME] | 51 | 2020-04-18 00:00:00
49 | [NAME] | 38 | 2020-04-30 00:00:00
50 | Rubi | 66 | 2020-05-04 00:00:00
51 | [NAME] | 74 | 2020-05-16 00:00:00
52 | Rohan | 33 | 2020-05-20 00:00:00
53 | Kuldeep | 20 | 2020-06-01 00:00:00
54 | [NAME] | 48 | 2020-06-05 00:00:00
55 | [NAME] | 36 | 2020-06-17 00:00:00
56 | Vinit | 51 | 2020-06-21 00:00:00
57 | Manoj | 11 | 2020-07-03 00:00:00
58 | Vikram | 45 | 2020-07-07 00:00:00
59 | Ravi | 74 | 2020-07-19 00:00:00
60 | Ramaiya | 73 | 2020-07-23 00:00:00
61 | Kuldeep | 77 | 2020-08-04 00:00:00
62 | [NAME] | 90 | 2020-08-08 00:00:00
63 | [NAME] | 76 | 2020-08-20 00:00:00
64 | Vinit | 66 | 2020-08-24 00:00:00
65 | Manoj | 95 | 2020-09-05 00:00:00
66 | Vikram | 45 | 2020-09-09 00:00:00
67 | Ravi | 100 | 2020-09-21 00:00:00
68 | Ramaiya | 91 | 2020-09-25 00:00:00
69 | Jupiter | 63 | 2020-10-07 00:00:00
70 | Anoj | 35 | 2020-10-11 00:00:00
71 | [NAME] | 94 | 2020-10-23 00:00:00
72 | Manish | 100 | 2020-10-27 00:00:00
73 | Vinod | 91 | 2020-11-08 00:00:00
74 | Iqbal | 80 | 2020-11-12 00:00:00
75 | [NAME] | 99 | 2020-11-24 00:00:00
76 | [NAME] | 31 | 2020-11-28 00:00:00
77 | [NAME] | 83 | 2020-12-10 00:00:00
78 | Rubi | 61 | 2020-12-14 00:00:00
79 | [NAME] | 62 | 2020-12-26 00:00:00
80 | Rohan | 31 | 2020-12-30 00:00:00
81 | Kuldeep | 58 | 2021-01-11 00:00:00
82 | [NAME] | 23 | 2021-01-15 00:00:00
83 | [NAME] | 96 | 2021-01-27 00:00:00
84 | Vinit | 56 | 2021-01-31 00:00:00
85 | Manoj | 12 | 2021-02-12 00:00:00
86 | Vikram | 18 | 2021-02-16 00:00:00
87 | Ravi | 46 | 2021-02-28 00:00:00
88 | Ramaiya | 46 | 2021-03-04 00:00:00
89 | Anoj | 78 | 2021-03-16 00:00:00
90 | [NAME] | 89 | 2021-03-20 00:00:00
91 | Manish | 49 | 2021-04-01 00:00:00
92 | Vinod | 12 | 2021-04-05 00:00:00
93 | Iqbal | 78 | 2021-04-17 00:00:00
94 | [NAME] | 47 | 2021-04-21 00:00:00
95 | [NAME] | 63 | 2021-05-03 00:00:00
96 | Iqbal | 23 | 2021-05-07 00:00:00
97 | [NAME] | 59 | 2021-05-19 00:00:00
98 | [NAME] | 45 | 2021-05-23 00:00:00
99 | [NAME] | 61 | 2021-06-04 00:00:00
100 | Rubi | 30 | 2021-06-08 00:00:00
101 | [NAME] | 68 | 2021-06-20 00:00:00
102 | Rohan | 80 | 2021-06-24 00:00:00
103 | Kuldeep | 22 | 2021-07-06 00:00:00
104 | [NAME] | 84 | 2021-07-10 00:00:00
105 | [NAME] | 61 | 2021-07-22 00:00:00
106 | Vinit | 25 | 2021-07-26 00:00:00
107 | Manoj | 54 | 2021-08-07 00:00:00
108 | Vikram | 69 | 2021-08-11 00:00:00
109 | Ravi | 29 | 2021-08-23 00:00:00
110 | Ramaiya | 65 | 2021-08-27 00:00:00
111 | Kuldeep | 55 | 2021-09-08 00:00:00
112 | [NAME] | 10 | 2021-09-12 00:00:00
113 | [NAME] | 67 | 2021-09-24 00:00:00
114 | Vinit | 19 | 2021-09-28 00:00:00
115 | Manoj | 34 | 2021-10-10 00:00:00
116 | Vikram | 25 | 2021-10-14 00:00:00
117 | Ravi | 40 | 2021-10-26 00:00:00
118 | Ramaiya | 16 | 2021-10-30 00:00:00
119 | Jupiter | 24 | 2021-11-11 00:00:00
120 | Anoj | 21 | 2021-11-15 00:00:00
121 | [NAME] | 56 | 2021-11-27 00:00:00
122 | Manish | 73 | 2021-12-01 00:00:00
123 | Vinod | 47 | 2021-12-13 00:00:00
124 | Iqbal | 43 | 2021-12-17 00:00:00
125 | [NAME] | 30 | 2021-12-29 00:00:00
126 | [NAME] | 23 | 2022-01-02 00:00:00
127 | [NAME] | 50 | 2022-01-14 00:00:00
128 | Rubi | 25 | 2022-01-18 00:00:00
129 | [NAME] | 85 | 2022-01-30 00:00:00
130 | Rohan | 27 | 2022-02-03 00:00:00
131 | Kuldeep | 50 | 2022-02-15 00:00:00
132 | [NAME] | 39 | 2022-02-19 00:00:00
133 | [NAME] | 62 | 2022-03-03 00:00:00
134 | Vinit | 86 | 2022-03-07 00:00:00
135 | Manoj | 75 | 2022-03-19 00:00:00
136 | Vikram | 24 | 2022-03-23 00:00:00
137 | [NAME] | 11 | 2022-04-04 00:00:00
138 | [NAME] | 52 | 2022-04-08 00:00:00
139 | Vinit | 39 | 2022-04-20 00:00:00
140 | Manoj | 10 | 2022-04-24 00:00:00
141 | Vikram | 60 | 2022-05-06 00:00:00
142 | Ravi | 40 | 2022-05-10 00:00:00
143 | Ramaiya | 29 | 2022-05-22 00:00:00
144 | Jupiter | 69 | 2022-05-26 00:00:00
145 | Anoj | 54 | 2022-06-07 00:00:00
146 | [NAME] | 25 | 2022-06-11 00:00:00
147 | Manish | 17 | 2022-06-23 00:00:00
148 | Vinod | 78 | 2022-06-27 00:00:00
149 | Iqbal | 85 | 2022-06-30 00:00:00
150 | [NAME] | 57 | 2022-07-04 00:00:00
151 | [NAME] | 97 | 2022-07-07 00:00:00
152 | [NAME] | 34 | 2022-07-11 00:00:00
153 | Rubi | 30 | 2022-07-14 00:00:00
154 | [NAME] | 59 | 2022-07-18 00:00:00
155 | Rohan | 11 | 2022-07-21 00:00:00
156 | Kuldeep | 84 | 2022-07-25 00:00:00
157 | [NAME] | 96 | 2022-07-28 00:00:00
158 | [NAME] | 54 | 2022-08-01 00:00:00
159 | Vinit | 96 | 2022-08-04 00:00:00
160 | Manoj | 37 | 2022-08-08 00:00:00
161 | Vikram | 68 | 2022-08-11 00:00:00
162 | Ravi | 57 | 2022-08-15 00:00:00
163 | Ramaiya | 58 | 2022-08-18 00:00:00
164 | Anoj | 43 | 2022-08-22 00:00:00
165 | [NAME] | 100 | 2022-08-25 00:00:00
166 | Manish | 63 | 2022-08-29 00:00:00
167 | Vinod | 13 | 2022-09-01 00:00:00
168 | Iqbal | 27 | 2022-09-05 00:00:00
169 | [NAME] | 63 | 2022-09-08 00:00:00
170 | [NAME] | 23 | 2022-09-12 00:00:00
171 | Iqbal | 83 | 2022-09-15 00:00:00
172 | [NAME] | 81 | 2022-09-19 00:00:00
173 | [NAME] | 59 | 2022-09-22 00:00:00
174 | [NAME] | 65 | 2022-09-26 00:00:00
175 | Rubi | 34 | 2022-09-29 00:00:00
176 | [NAME] | 52 | 2022-10-03 00:00:00
177 | Rohan | 22 | 2022-10-06 00:00:00
178 | Kuldeep | 66 | 2022-10-10 00:00:00
179 | [NAME] | 52 | 2022-10-13 00:00:00
180 | [NAME] | 11 | 2022-10-17 00:00:00
181 | Vinit | 71 | 2022-10-20 00:00:00
182 | Manoj | 61 | 2022-10-24 00:00:00
183 | Vikram | 86 | 2022-10-27 00:00:00
184 | Ravi | 76 | 2022-10-31 00:00:00
185 | Ramaiya | 98 | 2022-11-03 00:00:00
186 | Kuldeep | 36 | 2022-11-07 00:00:00
187 | [NAME] | 10 | 2022-11-10 00:00:00
188 | [NAME] | 94 | 2022-11-14 00:00:00
189 | Vinit | 65 | 2022-11-17 00:00:00
190 | Manoj | 44 | 2022-11-21 00:00:00
191 | Vikram | 63 | 2022-11-24 00:00:00
192 | Ravi | 47 | 2022-11-28 00:00:00
193 | Ramaiya | 42 | 2022-12-01 00:00:00
194 | Jupiter | 88 | 2022-12-05 00:00:00
195 | Anoj | 95 | 2022-12-08 00:00:00
196 | [NAME] | 54 | 2022-12-12 00:00:00
197 | Manish | 37 | 2022-12-15 00:00:00
198 | Jupiter | 86 | 2022-12-18 00:00:00
199 | Ramaiya | 53 | 2022-12-21 00:00:00
200 | Ravi | 79 | 2022-12-24 00:00:00
201 | Vikram | 44 | 2022-12-27 00:00:00
202 | Manoj | 73 | 2022-12-30 00:00:00
203 | Vinit | 86 | 2023-01-02 00:00:00
204 | [NAME] | 86 | 2023-01-05 00:00:00
205 | [NAME] | 60 | 2023-01-08 00:00:00
206 | Kuldeep | 80 | 2023-01-11 00:00:00
207 | Rohan | 90 | 2023-01-14 00:00:00
208 | [NAME] | 43 | 2023-01-17 00:00:00
209 | Rubi | 51 | 2023-01-20 00:00:00
210 | [NAME] | 88 | 2023-01-23 00:00:00
211 | [NAME] | 36 | 2023-01-26 00:00:00
212 | [NAME] | 31 | 2023-01-29 00:00:00
213 | Iqbal | 28 | 2023-02-01 00:00:00
214 | Vinod | 11 | 2023-02-04 00:00:00
215 | Manish | 27 | 2023-02-07 00:00:00
216 | [NAME] | 30 | 2023-02-10 00:00:00
217 | Anoj | 91 | 2023-02-13 00:00:00