在B20输入公式
=IF($A20=,,VLOOKUP(--MID(A20,2,LEN($A20)-2),$A$2:$C$16,MATCH(B$19,$A$1,$A$3,),FALSE))
再向右向下拉B20单元格就可以了!


- 相关评论
- 我要评论
-
2023-09-15 22:16:35
1916
2023-05-11 03:08:16
1688
2023-07-14 18:57:43
1299
2023-08-02 08:51:45
1080
2023-04-30 21:14:51
929
2023-02-19 21:59:07
862
2023-10-12 14:20:36
858
2023-06-06 16:52:40
795
2023-09-26 01:28:14
758
2023-09-26 15:07:29
585
2023-07-28 13:04:12
574
2023-09-21 06:48:57
558
2022-12-25 14:00:34
523
2023-08-02 20:13:35
495
2022-12-25 14:00:34
485
2023-07-02 09:27:28
473
2022-12-29 04:25:16
456
2023-06-25 00:07:00
451
2023-07-02 06:27:34
446
2023-08-02 20:28:53
434
2023-11-20 10:02:51
432
2023-10-31 11:03:26
428
2024-11-17 06:33:05
421
2023-05-09 21:11:22
412
2023-05-11 17:26:28
407
2023-09-18 04:24:24
406
2023-09-26 12:42:08
406
2023-05-04 03:11:25
403
2023-10-05 01:33:57
400
2023-09-21 16:24:51
394
2023-10-22 00:34:59
384
2022-12-22 05:12:05
383
2023-12-20 14:02:37
383
2023-09-23 05:28:46
382
2023-07-25 04:16:15
377
2023-08-03 06:14:01
375
2024-04-15 08:02:22
374
2023-07-14 06:17:35
368
2024-11-28 05:32:33
366
2023-10-16 11:40:04
363
2023-10-01 05:50:08
361
2022-12-20 23:24:34
358
2022-12-28 18:49:26
357
2023-01-12 16:55:57
352
2023-06-10 23:19:47
349
2024-04-03 04:04:05
348
2024-05-29 06:11:24
348
2023-10-25 09:48:41
346
2023-08-09 20:22:30
343
2024-06-24 05:49:22
341