Spreadsheet: 680537d1591082339-vlookup-not-working-properly-receiving-as-values-how-to-rectify-this-data_table
Sheet: Sheet1

StaffId | Id | Year | Week | PlanSubmitOn | ActualSubmitOn
467 | 4257 | 2020 | 22 | 2020-05-19 17:09:38 | 2020-05-29 10:02:24
153 | 4258 | 2020 | 22 | 2020-05-22 10:24:34 | 2020-05-30 16:57:04
470 | 4259 | 2020 | 22 | 2020-05-22 10:47:05 | 2020-05-29 18:22:48
477 | 4260 | 2020 | 22 | 2020-05-22 15:11:11 | 2020-05-29 17:06:10
456 | 4261 | 2020 | 22 | 2020-05-22 17:52:27 | 2020-05-31 23:12:25
386 | 4262 | 2020 | 22 | 2020-05-22 18:12:19 | 2020-05-29 18:28:21
84 | 4263 | 2020 | 22 | 2020-05-22 19:10:22 | 2020-05-29 19:21:18
499 | 4264 | 2020 | 22 | 2020-05-22 20:14:07 | 2020-06-01 08:46:33
450 | 4265 | 2020 | 22 | 2020-05-2 | 2020-05-30 14:37:04
475 | 4266 | 2020 | 22 | 2020-05-23 11:58:41 | 2020-05-30 14:06:00
496 | 4267 | 2020 | 22 | 2020-05-23 15:10:57 | 2020-05-30 16:47:09
498 | 4269 | 2020 | 22 | 2020-05-23 16:07:30 | #[NAME]!
457 | 4270 | 2020 | 22 | 2020-05-23 22:18:44 | 2020-05-31 03:38:23
478 | 4271 | 2020 | 22 | 2020-05-24 00:58:40 | 2020-05-31 22:34:19
460 | 4272 | 2020 | 22 | 2020-05-24 10:30:16 | 2020-05-31 11:53:20
125 | 4273 | 2020 | 22 | 2020-05-24 16:15:11 | 2020-05-31 20:07:44
434 | 4274 | 2020 | 22 | 2020-05-24 17:12:32 | 2020-05-31 12:25:22
443 | 4275 | 2020 | 22 | 2020-05-24 23:55:52 | 2020-05-30 18:48:54
505 | 4276 | 2020 | 22 | 2020-05-24 19:59:04 | 2020-05-31 12:04:03
468 | 4277 | 2020 | 22 | 2020-05-24 20:19:15 | 2020-05-31 22:12:06
116 | 4279 | 2020 | 22 | 2020-05-24 21:02:35 | 2020-05-31 20:38:41
237 | 4280 | 2020 | 22 | 2020-05-24 21:54:44 | #[NAME]!
473 | 4281 | 2020 | 22 | 2020-05-24 23:27:10 | 2020-05-31 21:49:13
471 | 4282 | 2020 | 22 | 2020-05-24 23:43:05 | 2020-05-31 22:19:43
128 | 4283 | 2020 | 22 | 2020-05-25 00:24:08 | 2020-05-31 22:26:48
140 | 4284 | 2020 | 22 | 2020-05-25 00:34:08 | 2020-05-31 17:00:41
126 | 4285 | 2020 | 22 | 2020-05-25 00:35:32 | 2020-06-01 00:18:47
454 | 4286 | 2020 | 22 | 2020-05-25 02:21:58 | 2020-06-01 06:50:59
88 | 4287 | 2020 | 22 | 2020-05-25 06:39:11 | 2020-06-01 00:14:06
364 | 4288 | 2020 | 22 | 2020-05-25 07:47:03 | 2020-05-31 18:03:39
96 | 4289 | 2020 | 22 | 2020-05-25 08:18:33 | 2020-05-31 15:00:44
503 | 4290 | 2020 | 22 | 2020-05-25 08:24:19 | #[NAME]!
464 | 4291 | 2020 | 22 | 2020-05-25 08:45:31 | 2020-05-31 22:31:32
436 | 4292 | 2020 | 22 | 2020-05-25 14:18:45 | 2020-05-31 20:50:33
123 | 4293 | 2020 | 22 | #[NAME]! | 2020-05-31 19:43:25
363 | 4294 | 2020 | 22 | #[NAME]! | 2020-05-31 16:22:18
467 | 4295 | 2020 | 23 | 2020-05-27 15:31:20 | #[NAME]!
478 | 4296 | 2020 | 23 | 2020-05-28 17:58:12 | #[NAME]!
477 | 4297 | 2020 | 23 | 2020-05-29 17:06:19 | #[NAME]!
470 | 4298 | 2020 | 23 | 2020-05-29 18:20:54 | #[NAME]!
386 | 4299 | 2020 | 23 | 2020-05-29 18:26:16 | #[NAME]!
450 | 4300 | 2020 | 23 | 2020-05-30 10:00:15 | #[NAME]!
498 | 4301 | 2020 | 23 | 2020-05-30 12:24:44 | #[NAME]!
475 | 4302 | 2020 | 23 | 2020-05-30 14:05:51 | #[NAME]!
497 | 4303 | 2020 | 22 | #[NAME]! | 2020-05-30 15:16:01
153 | 4304 | 2020 | 23 | 2020-05-30 16:53:11 | #[NAME]!
496 | 4305 | 2020 | 23 | 2020-05-30 16:55:52 | #[NAME]!
237 | 4306 | 2020 | 23 | 2020-05-30 22:53:21 | #[NAME]!
457 | 4307 | 2020 | 23 | 2020-05-31 03:38:31 | #[NAME]!
120 | 4308 | 2020 | 22 | #[NAME]! | 2020-05-31 11:40:28
120 | 4309 | 2020 | 23 | 2020-05-31 11:44:02 | #[NAME]!
460 | 4310 | 2020 | 23 | 2020-05-31 12:07:49 | #[NAME]!
434 | 4311 | 2020 | 23 | 2020-05-31 12:23:39 | #[NAME]!
96 | 4312 | 2020 | 23 | 2020-05-31 15:00:29 | #[NAME]!
363 | 4313 | 2020 | 23 | 2020-05-31 16:23:40 | #[NAME]!
443 | 4314 | 2020 | 23 | 2020-05-31 16:30:14 | #[NAME]!
474 | 4315 | 2020 | 23 | 2020-05-31 17:53:22 | #[NAME]!
474 | 4316 | 2020 | 22 | #[NAME]! | 2020-05-31 17:53:32
364 | 4317 | 2020 | 23 | 2020-05-31 18:13:47 | #[NAME]!
505 | 4318 | 2020 | 23 | 2020-05-31 19:11:56 | #[NAME]!
480 | 4319 | 2020 | 22 | #[NAME]! | 2020-05-31 19:28:29
94 | 4320 | 2020 | 22 | #[NAME]! | 2020-05-31 19:39:56
455 | 4321 | 2020 | 22 | #[NAME]! | 2020-05-31 19:42:24
455 | 4322 | 2020 | 23 | 2020-05-31 19:42:35 | #[NAME]!
94 | 4323 | 2020 | 23 | 2020-05-31 19:46:34 | #[NAME]!
123 | 4324 | 2020 | 23 | 2020-05-31 19:57:28 | #[NAME]!
125 | 4325 | 2020 | 23 | 2020-05-31 20:03:01 | #[NAME]!
480 | 4326 | 2020 | 23 | 2020-05-31 20:08:56 | #[NAME]!
116 | 4327 | 2020 | 23 | 2020-05-31 20:38:01 | #[NAME]!
431 | 4328 | 2020 | 22 | #[NAME]! | 2020-05-31 20:56:13
431 | 4329 | 2020 | 23 | 2020-05-31 21:02:30 | #[NAME]!
436 | 4330 | 2020 | 23 | 2020-05-31 21:08:30 | #[NAME]!
473 | 4331 | 2020 | 23 | 2020-05-31 22:07:15 | #[NAME]!
432 | 4332 | 2020 | 22 | #[NAME]! | 2020-05-31 22:11:06
468 | 4333 | 2020 | 23 | 2020-05-31 22:11:12 | #[NAME]!
432 | 4334 | 2020 | 23 | 2020-05-31 22:14:32 | #[NAME]!
128 | 4335 | 2020 | 23 | 2020-05-31 22:23:12 | #[NAME]!
140 | 4336 | 2020 | 23 | 2020-05-31 22:24:41 | #[NAME]!
471 | 4337 | 2020 | 23 | 2020-05-31 23:06:11 | #[NAME]!
456 | 4338 | 2020 | 23 | 2020-05-31 23:12:33 | #[NAME]!
452 | 4339 | 2020 | 22 | #[NAME]! | 2020-05-31 23:20:01
452 | 4340 | 2020 | 23 | 2020-05-31 23:36:23 | #[NAME]!
126 | 4341 | 2020 | 23 | 2020-06-01 00:09:09 | #[NAME]!
88 | 4342 | 2020 | 23 | 2020-06-01 00:14:45 | #[NAME]!
454 | 4343 | 2020 | 23 | 2020-06-01 06:50:47 | #[NAME]!
144 | 4344 | 2020 | 23 | 2020-06-01 07:09:30 | #[NAME]!
144 | 4345 | 2020 | 22 | #[NAME]! | 2020-06-01 07:14:34
449 | 4346 | 2020 | 23 | 2020-06-01 07:35:25 | #[NAME]!
84 | 4347 | 2020 | 23 | 2020-06-01 08:22:45 | #[NAME]!
251 | 4348 | 2020 | 22 | #[NAME]! | 2020-06-01 08:31:09
251 | 4349 | 2020 | 23 | 2020-06-01 08:34:07 | #[NAME]!
118 | 4350 | 2020 | 22 | #[NAME]! | 2020-06-01 08:34:18
118 | 4351 | 2020 | 23 | 2020-06-01 08:34:36 | #[NAME]!
500 | 4352 | 2020 | 22 | #[NAME]! | 2020-06-01 08:41:17
101 | 4353 | 2020 | 23 | 2020-06-01 08:46:22 | #[NAME]!
499 | 4354 | 2020 | 23 | 2020-06-01 08:48:52 | #[NAME]!
464 | 4355 | 2020 | 23 | 2020-06-01 08:55:20 | #[NAME]!