Spreadsheet: 293561d1391022754-compare-2-columns-for-a-match-and-populate-a-3rd-column-with-a-value-where-one-exists-copy
Sheet: MTH 11th

1130871 | 2
1130969 | 2
1131046 | 2
1131106 | 2
1131289 | 2
1131286 | 2.5
1131295 | 2.5
1131432 | 2.5
1131465 | 2.5
1131251 | 7.5
1131338 | 7.5
1131333 | 7.5
1131344 | 7.5
1131191 | 8
1130697 | 8
1130706 | 8
1130714 | 8
1130716 | 8
1130718 | 8
1130721 | 8
1130722 | 8
1130723 | 8
1130726 | 8
1130727 | 8
1131469 | 2.5
1130953 | 9
1131230 | 4.5
1131240 | 4.5
1131245 | 4.5
1131044 | 7.5
1131049 | 7.5
1131060 | 7.5
1131244 | 7.5
1130790 | 0
1131037 | 0
1131644 | 0
1131646 | 0
1131648 | 0
1131268 | 0
1130814 | 0
1130817 | 0
1130874 | 2.5
1130882 | 2.5
1130608 | 4
1130612 | 4
1130615 | 4
1130619 | 4
1130623 | 4
1130628 | 4
1130629 | 4
1130692 | 4.5
1130960 | 4.5
1131123 | 4.5
1131141 | 4.5
1131163 | 4.5
1131246 | 4.5
1130908 | 2.5
1131609 | 2.5
1131613 | 2.5
1129710 | 10.5
1131069 | 0
1131242 | 0
1130886 | 0
1131514 | 5
1131423 | 10.5
1130652 | 5
1130686 | 5
1131337 | 5
1131343 | 5
1130584 | 5.5
1130750 | 5.5
1131071 | 10.5
1130574 | 2.5
1130575 | 2.5
1131548 | 7.5
1131550 | 7.5
1130699 | 5
1130864 | 7.5
1131326 | 7.5
1131348 | 0
1131353 | 0
1131357 | 0
1130076 | 2.5
1130084 | 2.5
1130087 | 2.5
1130586 | 2.5
1130964 | 2.5
1131078 | 0
1128360 | 7.5
1131538 | 6.5
1131555 | 0
1131559 | 0
1131566 | 0
1131573 | 0
1131586 | 0
1131587 | 0
1131589 | 0
1131590 | 0
1131592 | 0
1131634 | 0
1131635 | 0
1130634 | 9
1130662 | 9
1130745 | 9
1130760 | 9
1130823 | 9
1130888 | 9
1131197 | 9
1131226 | 9
1131159 | 5
1126966 | 5.5
1127547 | 5.5
1129638 | 5.5
1129639 | 5.5
1129642 | 5.5
1129645 | 5.5
1129647 | 5.5
1130101 | 5.5
1130103 | 5.5
1130108 | 5.5
1130112 | 5.5
1130113 | 5.5
1130114 | 5.5
1130115 | 5.5
1130116 | 5.5
1130117 | 5.5
1130118 | 5.5
1130119 | 5.5
1130120 | 5.5
1130121 | 5.5
1130122 | 5.5
1130123 | 5.5
1130124 | 5.5
1130127 | 5.5
1126329 | 10.25
1128813 | 9
1130565 | 9
1130567 | 9
1130568 | 9
1130569 | 9
1130570 | 9
1130571 | 9
1130743 | 8
1130898 | 9
1131673 | 0
1131674 | 0
1131675 | 0
1129449 | 5
1130828 | 8.5
1130840 | 8.5
1127900 | 3
1130746 | 3
1130773 | 3
1130776 | 3
1131173 | 3
1131177 | 3
1131178 | 3
1131180 | 3
1131183 | 3
1131264 | 3
1131272 | 3
1131276 | 3
1131380 | 3
1130957 | 4.5
1129329 | 3.5
1131300 | 5
1129496 | 7.5
1131303 | 7.5
1131307 | 7.5
1131312 | 7.5
1131062 | 0
1131074 | 0
1131166 | 0
1131168 | 0
1131281 | 4
1131285 | 4
1127919 | 6
1129434 | 6
1131052 | 10.25
1131227 | 10.25
1130880 | 10.25
1130885 | 10.25
1130889 | 10.25
1130891 | 10.25
1130896 | 10.25
1130901 | 10.25
1130914 | 10.25
1131127 | 10.25
1131328 | 10.25
1130904 | 3
1130605 | 8
1130625 | 8
1130822 | 8
1130895 | 8
1131058 | 8
1131260 | 8
1131304 | 8
1129466 | 5
1131104 | 5
1131128 | 5
1129547 | 10.25
1130922 | 10.25
1130924 | 10.25
1130929 | 10.25
1131277 | 9
1130859 | 5
1130872 | 5
1129543 | 5
1129549 | 5
1130682 | 5
1131154 | 2.5
1131161 | 2.5
1131087 | 7.5
1131437 | 7.5
1131539 | 7.5
1130734 | 0
1131368 | 0
1130820 | 7.5
1130826 | 0
1130798 | 10.25
1130801 | 10.25
1129595 | 10.25
1130603 | 10.25
1130617 | 10.25
1130696 | 10.25
1130802 | 10.25
1131035 | 10.25
1130788 | 0
1130800 | 0
1131901 | 0
1128517 | 0
1128527 | 0
1129619 | 0
1130037 | 0
1130149 | 0
1129990 | 0
1130711 | 6.5
1131164 | 6.5
1131067 | 10.25
1131119 | 10.25
1130981 | 10
1131189 | 10
1131012 | 10.25
1130741 | 10.25
1130858 | 10.25
1130029 | 0
1130939 | 4
1130947 | 4
1130601 | 9
1130913 | 9
1130848 | 5
1130946 | 5
1131098 | 10.25
1131116 | 10.25
1130059 | 5
1130062 | 5
1130596 | 5
1130693 | 5
1130846 | 7
1130085 | 10
1130654 | 10.25
1130670 | 10.25
1130685 | 10.25
1130979 | 3
1130665 | 8
1130719 | 10.25
1130740 | 10.25
1131459 | 8
1131464 | 8
1130635 | 2.5
1130667 | 2.5
1131298 | 5
1129393 | 10.25
1131737 | 2.5
1129674 | 10.25
1130862 | 10.25
1130870 | 10.25
1130883 | 10.25
1130900 | 10.25
1130909 | 10.25
1130919 | 10.25
1130556 | 7.5
1129553 | 3.5
1130861 | 3.5
1130873 | 3.5
1130918 | 3.5
1131021 | 3.5
1131162 | 3.5
1131015 | 0
1131317 | 0
1131324 | 0
1131497 | 0
1131500 | 0
1131502 | 0
1131504 | 0
1130657 | 5
1130748 | 5
1130998 | 5
1131030 | 5
1130876 | 4.5
1131196 | 4.5
1131198 | 4.5
1131056 | 10.25
1131066 | 10.25
1131072 | 10.25
1131073 | 10.25
1131077 | 10.25
1131089 | 10.25
1131426 | 10.25
1131427 | 10.25
1131489 | 10.25
1131713 | 10.25
1131152 | 10.25
1131155 | 10.25
1131193 | 7.5
1131642 | 7.5
1131365 | 2.5
1131022 | 0
1131023 | 0
1131026 | 0
1128173 | 9
1129827 | 9
1130690 | 2.5
1130708 | 2.5
1130959 | 2.5
1130752 | 7.5
1131243 | 7.5
1131192 | 7.5
1130784 | 10
1130786 | 10
1130809 | 10
1131108 | 10
1129454 | 10.25
1129462 | 10.25
1124774 | 10.25
1131114 | 10.25
1131270 | 10.25
1128518 | 5
1128522 | 5
1128526 | 5
1128543 | 5
1128545 | 5
1128551 | 5
1128555 | 5
1130679 | 3.5
1131129 | 2.5
1131133 | 2.5
1131253 | 2.5
1131294 | 2.5
1131382 | 2.5
1131430 | 2.5
1131533 | 2.5
1131697 | 2.5
1131729 | 2.5
1130836 | 5
1130991 | 7
1130999 | 7
1131386 | 7
1130810 | 7.5
1131580 | 6.5
1131582 | 6.5
1131534 | 6.5
1131274 | 6.5
1131310 | 6.5
1131321 | 6.5
1131341 | 0
1131346 | 0
1131349 | 0
1131355 | 0
1131361 | 0
1131363 | 0
1131366 | 0
1131367 | 0
1131376 | 0
1131378 | 0
1131384 | 0
1131387 | 0
1131389 | 0
1131392 | 0
1131397 | 0
1131400 | 0
1131404 | 0
1131407 | 0
1131410 | 0
1131414 | 0
1131415 | 0
1131416 | 0
1131418 | 0
1131420 | 0
1131439 | 0
1131450 | 0
1131457 | 0
1131460 | 0
1131462 | 0
1131467 | 0
1131470 | 0
1131472 | 0
1131474 | 0
1131476 | 0
1131477 | 0
1131593 | 0
1131596 | 0
1131603 | 0
1131605 | 0
1131607 | 0
1131628 | 0
1131630 | 0
1131632 | 0
1131007 | 9
1131013 | 9
1131084 | 9
1131132 | 9
1131156 | 9
1131201 | 9
1131335 | 9
1131340 | 9
1131383 | 9
1131396 | 9
1131554 | 9
1131588 | 9
1131591 | 9
1131637 | 9
1131638 | 9
1131639 | 9
1131641 | 9
1131666 | 9
1130158 | 9
1131262 | 2.5
1131421 | 2.5
1130936 | 9
1130580 | 10.25
1130995 | 9
1131428 | 2.5
1131541 | 2.5
1131038 | 5
1131373 | 0
1131732 | 0
1131761 | 0
1130926 | 0
1130933 | 0
1131093 | 0
1131544 | 2.5
1131678 | 2.5
1131702 | 2.5
1129828 | 10.25
1131149 | 10.25
1131257 | 10.25
1130948 | 10.25
1131040 | 10.25
1131079 | 10.25
1131560 | 7.5
1131562 | 7.5
1130768 | 7.5
1130772 | 7.5
1130775 | 7.5
1129433 | 5
1130782 | 5
1130793 | 5
1130816 | 5
1130857 | 5
1130867 | 5
1131516 | 7.5
1131518 | 7.5
1131522 | 7.5
1131524 | 7.5
1131526 | 7.5
1131528 | 7.5