Spreadsheet: 488050d1478456082-how-to-check-which-value-could-not-be-matched-while-using-vlookup-vlookup
Sheet: Source

614935 | 3
615065 | 11
615067 | 11
615089 | 8
615090 | 12
615092 | 8
615662 | 7
615934 | 13
615948 | 16
615968 | 8
618934 | 14
619065 | 14
619089 | 3
619090 | 34
619092 | 6
619662 | 7
619935 | 14
619968 | 6
1214901 | 11
1216901 | 21
1515007 | 10
1516066 | 64
1525111 | 42
1612076 | 4
1612084 | 16
1614027 | 12
1614076 | 5
1614094 | 4
1614149 | 3
1615045 | 5
1615053 | 4
1615133 | 4
1615515 | 12
1615594 | 15
1615991 | 13
1615993 | 10
1616031 | 4
1616094 | 12
1616521 | 13
1617150 | 10
1617162 | 6
1618133 | 3
1619027 | 14
1619150 | 13
1619162 | 1
1619515 | 20
1619521 | 16
1619594 | 19
1619991 | 19
1895038 | 17
1895138 | 11
1895438 | 24
1898038 | 19
1899038 | 18
3211038 | 82
3211059 | 6
3211905 | 2
3212915 | 9
3215061 | 10
3215913 | 10
3216030 | 1
3216905 | 9
3216915 | 9
3218061 | 4
3218913 | 10
3511031 | 19
3511047 | 152
3511050 | 22
3511082 | 33
3511084 | 35
3515908 | 4
3515914 | 13
3516026 | 32
3516028 | 19
3516029 | 104
3516062 | 25
3516064 | 30
3516066 | 166
3516076 | 2
3516907 | 10
3516912 | 13
3516914 | 13
3519907 | 1
3546054 | 5
3612084 | 17
3612529 | 11
3614005 | 4
3614028 | 14
3614031 | 13
3614053 | 4
3614056 | 14
3614059 | 5
3614073 | 9
3614126 | 5
3614154 | 1
3614155 | 14
3614157 | 5
3614164 | 9
3614525 | 19
3614992 | 3
3615016 | 3
3615040 | 17
3615052 | 14
3615062 | 12
3615076 | 21
3615099 | 6
3615113 | 6
3615145 | 13
3615147 | 9
3615156 | 17
3615160 | 11
3615168 | 16
3615173 | 2
3615511 | 18
3615517 | 14
3615518 | 9
3615521 | 18
3615526 | 14
3615527 | 19
3615529 | 25
3615531 | 12
3615586 | 21
3615593 | 14
3615963 | 14
3615992 | 12
3615993 | 2
3616005 | 5
3616031 | 16
3616053 | 24
3616056 | 13
3616073 | 1
3616126 | 7
3616154 | 9
3616155 | 11
3616160 | 11
3616511 | 16
3616522 | 12
3616524 | 6
3616525 | 15
3616537 | 17
3616539 | 17
3616541 | 14
3616592 | 3
3617031 | 9
3617065 | 1
3617513 | 17
3617527 | 9
3617543 | 12
3617592 | 12
3618016 | 2
3618052 | 7
3618521 | 29
3618588 | 12
3619031 | 8
3619052 | 2
3619059 | 7
3619099 | 7
3619113 | 1
3619145 | 11
3619146 | 5
3619156 | 13
3619157 | 12
3619164 | 7
3619513 | 35
3619517 | 8
3619522 | 15
3619524 | 8
3619526 | 10
3619539 | 21
3619543 | 13
3619586 | 7
3619593 | 13
3643017 | 32
3645542 | 16
3775002 | 38
3775004 | 17
3775018 | 25
3777002 | 38
3777018 | 14
3779002 | 39
3779004 | 23
3895092 | 16
3896092 | 8
3899107 | 62
4081004 | 14
4081005 | 15
4211038 | 16
4211049 | 9
4212915 | 15
4216915 | 15
4219905 | 5
4511031 | 22
4511047 | 216
4511050 | 45
4511082 | 26
4511084 | 27
4516029 | 86
4546054 | 19
4612084 | 13
4614045 | 26
4614051 | 15
4614053 | 38
4614056 | 26
4614059 | 9
4614152 | 15
4614175 | 23
4615526 | 15
4615527 | 12
4616005 | 6
4616030 | 13
4616031 | 20
4616045 | 27
4616046 | 25
4616051 | 3
4616053 | 43
4616056 | 24
4616073 | 5
4616152 | 18
4616155 | 7
4616175 | 21
4616524 | 15
4617031 | 27
4617527 | 10
4619059 | 2
4619526 | 15
4643117 | 35
4645542 | 1
4715538 | 3
4717538 | 7
4772019 | 12
4775154 | 2
4776019 | 18
4891032 | 43
4899030 | 16
4899032 | 47
4899107 | 3
5082108 | 2
5216099 | 21
5512967 | 19
5516014 | 26
5516026 | 4
5516064 | 28
5516066 | 125
5516069 | 26
5516071 | 29
5516084 | 18
5516098 | 21
5516967 | 2
5516971 | 10
5516974 | 14
5516975 | 7
5516988 | 23
5518974 | 20
5518988 | 29
5525115 | 11
5526012 | 38
5526113 | 11
5526115 | 2
5529015 | 7
5612170 | 32
5612188 | 6
5614002 | 15
5614060 | 31
5614080 | 1
5614120 | 8
5614155 | 39
5614177 | 21
5614716 | 19
5614992 | 48
5614993 | 15
5615015 | 35
5615016 | 93
5615024 | 12
5615025 | 25
5615029 | 9
5615040 | 21
5615044 | 17
5615057 | 22
5615084 | 21
5615095 | 50
5615115 | 24
5615121 | 15
5615125 | 16
5615128 | 4
5615136 | 24
5615153 | 16
5615155 | 32
5615193 | 5
5615366 | 12
5615367 | 9
5615377 | 2
5615716 | 4
5615765 | 10
5615799 | 20
5615903 | 6
5615910 | 1
5615925 | 7
5615969 | 20
5615992 | 26
5616015 | 26
5616016 | 55
5616023 | 33
5616027 | 17
5616044 | 9
5616057 | 16
5616059 | 18
5616060 | 7
5616064 | 22
5616071 | 9
5616073 | 6
5616084 | 15
5616095 | 18
5616111 | 16
5616121 | 18
5616125 | 13
5616153 | 3
5616155 | 37
5616166 | 26
5616170 | 35
5616193 | 15
5616365 | 12
5616377 | 12
5616711 | 3
5616903 | 17
5616919 | 10
5616941 | 1
5616969 | 12
5617039 | 6
5617155 | 6
5617188 | 5
5617743 | 10
5617925 | 4
5618025 | 10
5618027 | 24
5618031 | 32
5618040 | 14
5618059 | 21
5618064 | 24
5618073 | 3
5618075 | 5
5618115 | 38
5618153 | 16
5618155 | 1
5618166 | 9
5618188 | 1
5618365 | 10
5618367 | 11
5618912 | 1
5618919 | 9
5618960 | 4
5618993 | 18
5619021 | 5
5619023 | 15
5619024 | 17
5619026 | 16
5619029 | 28
5619128 | 9
5619131 | 35
5619136 | 29
5619177 | 19
5619730 | 15
5619765 | 3
5619799 | 18
5625037 | 16
5626037 | 36
5629037 | 19
5712042 | 12
5715044 | 6
5716044 | 21
5718042 | 37
5719042 | 9
5725103 | 4
5729054 | 23
5729103 | 9
5729154 | 8
5775021 | 13
5775062 | 4
5775063 | 10
5775073 | 20
5775075 | 14
5775078 | 14
5775211 | 23
5776030 | 26
5777063 | 4
5777064 | 29
5779011 | 16
5779062 | 2
5779073 | 13
5812118 | 7
5816118 | 5
5891007 | 24
5891017 | 17
5892034 | 29
5893040 | 3
5895040 | 7
5895059 | 1
5895159 | 2
5896007 | 33
5896017 | 56
5896023 | 4
5896034 | 60
5896044 | 2
5896049 | 3
5896053 | 4
5896057 | 22
5896144 | 34
5896159 | 32
5899007 | 4
5899023 | 9
5899053 | 8
5899057 | 28
5899159 | 31
6516039 | 61
6516091 | 27
6516093 | 12
6611024 | 7
6611078 | 31
6612057 | 9
6612941 | 1
6613013 | 40
6614043 | 1
6614066 | 5
6614075 | 20
6614089 | 7
6614099 | 28
6614145 | 1
6614740 | 11
6614759 | 15
6614940 | 13
6614997 | 50
6615002 | 34
6615006 | 4
6615021 | 38
6615042 | 9
6615046 | 1
6615054 | 16
6615056 | 7
6615057 | 24
6615058 | 10
6615063 | 20
6615067 | 15
6615070 | 21
6615078 | 29
6615089 | 25
6615090 | 12
6615099 | 40
6615119 | 18
6615179 | 16
6615520 | 11
6615619 | 31
6615736 | 24
6615759 | 3
6615939 | 26
6615940 | 25
6615957 | 10
6615970 | 25
6615997 | 9
6616002 | 37
6616006 | 16
6616021 | 6
6616024 | 10
6616043 | 20
6616046 | 11
6616054 | 30
6616056 | 8
6616059 | 29
6616063 | 31
6616067 | 10
6616069 | 1
6616070 | 10
6616090 | 9
6616099 | 54
6616119 | 7
6616159 | 41
6616179 | 14
6616190 | 15
6616217 | 5
6616702 | 5
6616736 | 50
6616740 | 5
6616797 | 20
6616937 | 36
6616939 | 31
6616957 | 5
6617005 | 17
6618002 | 39
6618005 | 9
6618006 | 3
6618046 | 16
6618063 | 21
6618069 | 7
6618075 | 16
6618077 | 4
6618159 | 5
6618740 | 4
6618797 | 17
6618906 | 10
6618907 | 10
6618937 | 9
6618957 | 4
6619002 | 15
6619058 | 23
6619067 | 4
6619145 | 9
6619970 | 23
6625150 | 15
6625250 | 12
6626050 | 16
6627050 | 15
6644018 | 12
6646018 | 11
6712097 | 22
6713041 | 10
6713095 | 15
6714057 | 29
6714081 | 1
6715005 | 26
6715095 | 9
6715097 | 27
6715228 | 3
6715966 | 14
6716005 | 49
6716039 | 4
6716041 | 35
6716082 | 20
6716097 | 1
6716191 | 18
6718005 | 19
6718057 | 4
6718082 | 1
6718090 | 2
6718191 | 24
6718966 | 1
6724149 | 18
6726149 | 19
6744021 | 16
6744901 | 20
6744915 | 1
6744916 | 1
6746021 | 11
6746025 | 6
6746910 | 44
6746916 | 14
6749025 | 8
7611943 | 3
7614026 | 4
7614031 | 4
7614085 | 7
7614086 | 1
7615031 | 14
7615072 | 2
7615185 | 15
7615189 | 4
7615194 | 4
7615967 | 7
7615969 | 6
7616041 | 1
7616072 | 23
7616086 | 16
7616185 | 18
7616189 | 28
7616194 | 17
7616967 | 6
7617189 | 13
7618072 | 13
7619072 | 13
7619969 | 4
7714021 | 3
7714912 | 8
7715766 | 8
7715776 | 12
7716021 | 13
7716040 | 7
7716048 | 19
7716052 | 22
7716074 | 1
7716083 | 16
7716125 | 1
7716209 | 9
7716224 | 3
7716752 | 7
7716758 | 10
7716776 | 4
7716912 | 17
7716926 | 14
7716935 | 12
7718052 | 11
7718209 | 21
7718758 | 20
7718766 | 17
8081010 | 1
8081110 | 1
8081114 | 15
8081341 | 2
8081905 | 16
8082005 | 11
8082010 | 1
8082039 | 7
8082040 | 9
8082041 | 17
8082070 | 10
8082110 | 9
8082112 | 1
8082116 | 8
8082127 | 13
8082904 | 11
8082906 | 18
8085127 | 11
8086010 | 7
8086039 | 5
8086112 | 2
8086114 | 16
8086116 | 19
8086120 | 9
8086121 | 16
8086122 | 5
8086126 | 2
8086641 | 7
8086646 | 17
8086841 | 6
8086903 | 24
8086905 | 15
8086906 | 10
8087901 | 21
8089020 | 3
8089039 | 16
8089040 | 1
8089041 | 29
8089116 | 1
8089120 | 10
8089121 | 3
8089127 | 7
8089714 | 5
8089901 | 32
8146011 | 16
8146020 | 1
8146110 | 8
8146111 | 28
8211038 | 61
8211046 | 15
8211049 | 14
8212951 | 9
8214014 | 10
8214630 | 7
8214966 | 1
8214974 | 1
8216014 | 14
8216028 | 20
8216502 | 9
8216522 | 19
8216951 | 2
8216964 | 10
8216966 | 4
8216972 | 9
8216974 | 9
8219972 | 4
8219975 | 5
8232005 | 12
8239005 | 6
8246070 | 19
8246997 | 2
8282036 | 1
8282084 | 7
8282227 | 31
8282236 | 12
8286066 | 2
8286236 | 11
8289210 | 1
8289227 | 12
8511047 | 130
8511050 | 26
8511082 | 36
8511084 | 17
8513622 | 6
8513627 | 4
8514007 | 17
8514012 | 29
8514019 | 13
8514021 | 30
8514022 | 19
8514023 | 17
8514027 | 18
8514032 | 28
8514033 | 10
8514523 | 11
8514550 | 9
8514627 | 10
8514944 | 2
8514989 | 1
8516007 | 29
8516012 | 29
8516019 | 14
8516021 | 39
8516022 | 154
8516023 | 38
8516024 | 6
8516027 | 1
8516029 | 46
8516032 | 25
8516033 | 49
8516053 | 25
8516081 | 40
8516082 | 17
8516085 | 14
8516183 | 15
8516187 | 23
8516189 | 13
8516523 | 11
8516547 | 12
8516550 | 11
8516642 | 9
8516926 | 22
8516944 | 4
8516987 | 1
8524030 | 6
8524227 | 6
8526018 | 22
8526030 | 38
8526033 | 7
8526227 | 113
8544038 | 2
8544039 | 3
8544054 | 16
8544057 | 6
8546038 | 29
8546039 | 72
8546043 | 3
8546046 | 7
8546049 | 25
8546054 | 29
8546055 | 26
8546057 | 1
8546064 | 14
8546167 | 32
8546168 | 35
8546930 | 46
8546936 | 22
8546991 | 4
8546996 | 33
8612542 | 1
8612591 | 15
8612915 | 13
8612978 | 3
8613020 | 18
8613031 | 18
8614001 | 14
8614002 | 5
8614007 | 3
8614023 | 40
8614024 | 2
8614027 | 29
8614046 | 21
8614047 | 14
8614049 | 12
8614052 | 26
8614071 | 47
8614078 | 3
8614146 | 41
8614150 | 10
8614151 | 38
8614175 | 22
8614253 | 10
8614388 | 4
8614399 | 1
8614546 | 11
8614557 | 18
8614561 | 6
8614570 | 13
8614575 | 2
8614577 | 39
8614582 | 11
8614583 | 38
8614584 | 1
8614590 | 12
8614592 | 14
8614594 | 17
8614596 | 10
8614711 | 5
8614713 | 24
8614785 | 38
8614796 | 23
8614949 | 22
8614971 | 22
8614972 | 19
8614975 | 1
8614984 | 18
8614997 | 1
8615008 | 23
8615023 | 11
8615032 | 6
8615034 | 1
8615523 | 17
8615542 | 1
8615543 | 35
8615546 | 12
8615547 | 15
8615715 | 27
8615980 | 12
8615992 | 11
8616001 | 10
8616002 | 25
8616003 | 14
8616007 | 25
8616014 | 23
8616020 | 59
8616024 | 20
8616027 | 22
8616036 | 35
8616045 | 35
8616046 | 21
8616047 | 24
8616049 | 24
8616051 | 3
8616052 | 42
8616061 | 41
8616071 | 36
8616078 | 67
8616107 | 18
8616114 | 5
8616125 | 3
8616146 | 54
8616150 | 27
8616151 | 67
8616175 | 40
8616176 | 2
8616186 | 2
8616253 | 15
8616364 | 7
8616388 | 4
8616443 | 3
8616472 | 21
8616523 | 1
8616531 | 12
8616532 | 60
8616535 | 3
8616539 | 19
8616547 | 13
8616556 | 40
8616557 | 19
8616560 | 16
8616561 | 23
8616570 | 19
8616575 | 1
8616582 | 32
8616583 | 47
8616590 | 33
8616591 | 16
8616592 | 12
8616594 | 11
8616596 | 34
8616711 | 20
8616713 | 23
8616784 | 4
8616785 | 24
8616796 | 58
8616953 | 21
8616965 | 17
8616971 | 22
8616972 | 24
8616978 | 5
8616981 | 2
8616984 | 18
8616998 | 1
8617023 | 13
8617052 | 23
8617523 | 21
8617992 | 13
8618542 | 1
8619006 | 12
8619008 | 27
8619023 | 9
8619031 | 15
8619032 | 9
8619036 | 18
8619045 | 22
8619107 | 10
8619415 | 6
8619474 | 1
8619531 | 16
8619543 | 29
8619547 | 5
8619556 | 24
8619577 | 49
8619582 | 23
8619594 | 22
8619715 | 2
8619915 | 6
8619949 | 24
8619981 | 4
8624011 | 28
8624020 | 6
8624023 | 19
8624047 | 18
8624061 | 33
8624119 | 38
8626011 | 19
8626020 | 20
8626023 | 28
8626047 | 9
8626061 | 50
8628011 | 38
8628020 | 23
8628147 | 22
8643017 | 62
8643022 | 18
8643046 | 31
8643065 | 40
8644011 | 21
8644030 | 1
8644037 | 27
8644075 | 7
8644091 | 2
8644211 | 20
8644212 | 1
8644220 | 3
8644545 | 13
8644551 | 11
8644565 | 2
8644628 | 6
8644632 | 7
8644634 | 3
8644760 | 16
8644801 | 1
8644901 | 1
8644931 | 12
8644932 | 9
8646003 | 4
8646011 | 16
8646013 | 10
8646027 | 27
8646030 | 5
8646037 | 13
8646067 | 7
8646090 | 1
8646212 | 1
8646220 | 16
8646341 | 41
8646545 | 10
8646562 | 11
8646626 | 13
8646628 | 9
8646630 | 9
8646632 | 7
8646634 | 11
8646760 | 17
8646801 | 1
8646901 | 1
8646932 | 14
8646935 | 4
8646976 | 19
8712538 | 7
8712544 | 17
8712571 | 14
8714054 | 23
8714134 | 91
8714153 | 20
8714552 | 41
8714569 | 23
8714573 | 6
8714581 | 14
8714597 | 10
8714598 | 12
8714969 | 19
8714991 | 6
8715538 | 34
8715544 | 27
8715558 | 8
8715571 | 58
8716010 | 13
8716054 | 17
8716079 | 7
8716153 | 8
8716536 | 9
8716537 | 7
8716552 | 2
8716569 | 28
8716581 | 23
8716593 | 2
8716597 | 3
8716598 | 11
8716969 | 22
8718134 | 25
8719571 | 26
8722014 | 8
8724014 | 3
8724022 | 8
8724025 | 24
8724178 | 4
8724230 | 22
8726014 | 10
8726021 | 75
8726022 | 20
8726025 | 46
8726030 | 33
8726130 | 14
8726178 | 20
8726967 | 8
8727024 | 1
8728025 | 16
8728633 | 24
8729633 | 24
8743025 | 21
8744070 | 3
8744135 | 10
8744932 | 30
8744974 | 11
8746009 | 36
8746070 | 4
8746135 | 12
8746342 | 22
8746550 | 7
8746557 | 2
8746974 | 3
8746975 | 14
8772009 | 24
8772019 | 31
8772020 | 20
8772069 | 35
8775009 | 10
8775042 | 21
8775043 | 1
8775049 | 21
8775059 | 50
8775067 | 40
8775069 | 14
8775071 | 19
8775092 | 32
8775093 | 34
8775096 | 13
8775140 | 12
8775550 | 14
8775639 | 60
8776007 | 8
8776019 | 40
8776029 | 16
8776035 | 23
8776051 | 16
8776056 | 9
8776071 | 10
8776074 | 13
8777035 | 31
8777056 | 2
8778042 | 17
8778052 | 4
8778069 | 5
8778072 | 1
8778639 | 14
8779002 | 28
8779009 | 9
8779020 | 22
8779042 | 11
8779043 | 9
8779049 | 24
8779056 | 12
8779059 | 23
8779065 | 36
8779067 | 23
8779069 | 26
8779092 | 11
8779096 | 30
8779550 | 13
8779639 | 24
8812120 | 3
8814115 | 7
8814118 | 17
8814119 | 13
8814120 | 4
8814123 | 15
8814125 | 10
8816116 | 2
8816123 | 13
8816124 | 24
8816125 | 11
8816214 | 2
8819214 | 1
8891032 | 25
8892043 | 14
8892067 | 29
8892087 | 32
8893054 | 83
8894047 | 40
8895067 | 25
8895070 | 9
8895144 | 13
8896032 | 29
8896036 | 22
8896039 | 76
8896042 | 40
8896043 | 13
8896051 | 28
8896052 | 15
8896054 | 101
8896055 | 31
8896056 | 43
8896059 | 12
8896066 | 7
8896067 | 35
8896070 | 14
8896087 | 57
8896144 | 15
8897031 | 1
8897047 | 31
8898055 | 26
8899030 | 39
8899032 | 38
8899039 | 43
8899043 | 12
8899051 | 34
8899055 | 10
8899059 | 2
8899061 | 1
8899067 | 73
8899070 | 7
8899144 | 13
9000045 | 230
9000046 | 141
9001125 | 12
9004447 | 63
9006002 | 10
9006033 | 20
9006034 | 43
9006067 | 4
9006447 | 178
9211356 | 75
9224020 | 1
9224101 | 9
9224110 | 20
9224664 | 1
9226101 | 16
9226111 | 19
9226119 | 21
9226210 | 4
9226667 | 33
9226668 | 12
9311270 | 319
9311356 | 28
9316227 | 13
9332323 | 2
9333316 | 3
9334322 | 4
9334323 | 4
9335322 | 2
9335323 | 3
9336316 | 3
9336322 | 3
9336323 | 4
9337161 | 3
9411270 | 460
9411356 | 12
9416227 | 82
9514087 | 209
9516087 | 23
9881045 | 3
9881112 | 144
9881149 | 221
9881901 | 39
9881999 | 171
9882011 | 9
9882121 | 7
9882206 | 24
9882277 | 19
9882901 | 36
9882999 | 20
9884149 | 34
9884747 | 17
9884999 | 82
9885021 | 22
9885204 | 12
9885506 | 9
9886021 | 4
9886026 | 89
9886028 | 137
9886045 | 24
9886077 | 42
9886112 | 111
9886120 | 68
9886149 | 108
9886262 | 9
9886311 | 33
9886767 | 7
9886901 | 69
9886999 | 131
9887905 | 35
9889021 | 15
9889205 | 73
9889505 | 59
9889797 | 22
9889906 | 14
9889999 | 48
9935014 | 14