Spreadsheet: 137967d1327446534-wrong-use-of-vlookup-vl123
Sheet: Sheet1

140163 | 110013 | =VLOOKUP(A1,B1:B505,1,TRUE)
110013 | 110014
110014 | 110020
110024 | 110062
110036 | 110074
110072 | 110173
110089 | 110175
110327 | 110188
110428 | 110195
110750 | 110389
110872 | 110423
111014 | 110433
120045 | 110459
120850 | 110537
120865 | 110594
120946 | 110607
120950 | 110613
130536 | 110630
130704 | 110659
130734 | 110749
140101 | 110819
140225 | 110871
140306 | 110955
142255 | 111011
142299 | 111142
142925 | 120022
143251 | 120024
143295 | 120120
145021 | 120130
145022 | 120223
145085 | 120244
145095 | 120338
145129 | 120458
145133 | 130016
145135 | 130021
145138 | 130063
145174 | 130128
145282 | 130133
145323 | 130139
145344 | 130140
150074 | 130156
150088 | 130219
150171 | 130220
150298 | 130300
214642 | 130448
214732 | 130475
214733 | 130567
214740 | 130570
214743 | 130614
214774 | 130820
214795 | 130829
214807 | 130837
214887 | 130859
214901 | 140117
214903 | 140120
214904 | 140225
214916 | 140300
214930 | 145029
214938 | 145092
221323 | 145135
222116 | 145182
222276 | 145271
222348 | 145282
224852 | 145311
310134 | 145326
310585 | 150001
311066 | 150018
320059 | 150022
320061 | 150027
320106 | 150220
320166 | 150257
320669 | 150267
320672 | 150294
320735 | 150333
350100 | 211512
350798 | 211522
350819 | 211524
352026 | 211558
352060 | 211560
352096 | 211696
352219 | 211755
352369 | 211850
352439 | 211893
352869 | 212043
352871 | 212242
352885 | 212243
352934 | 212251
352936 | 212346
370111 | 212383
431691 | 212430
441507 | 212435
441916 | 212494
450030 | 212529
450950 | 212539
460237 | 212596
490058 | 212662
490063 | 212729
490065 | 212730
521681 | 213023
522149 | 213071
523587 | 213135
610766 | 213185
610772 | 213223
610814 | 213241
610926 | 213242
610935 | 213251
620284 | 213341
700701 | 213378
704534 | 213497
800120 | 213521
800166 | 213528
800654 | 213529
801002 | 213586
801014 | 213587
801020 | 213595
801024 | 213617
801061 | 213621
801335 | 213624
801398 | 213739
803808 | 213746
803813 | 213790
807447 | 213951
910039 | 214041
910123 | 214264
910129 | 214415
914048 | 214529
917119 | 214557
923044 | 214612
924055 | 214633
925012 | 214648
925014 | 214674
932032 | 214720
933003 | 214729
940078 | 214751
940080 | 214753
940082 | 214815
948032 | 214827
948034 | 214838
948042 | 221406
949034 | 221410
980195 | 221481
980236 | 222154
980772 | 222242
990009 | 222836
990049 | 222890
990145 | 222893
990182 | 224852
990235 | 224861
990258 | 310141
990260 | 310174
990261 | 310300
990516 | 310329
990613 | 310428
990698 | 310475
990742 | 310517
990749 | 310541
990814 | 310552
991053 | 310553
991157 | 310714
991444 | 310868
991445 | 310904
991604 | 320031
991640 | 320032
991749 | 320035
991854 | 320063
991858 | 320106
991986 | 320113
992100 | 320173
992103 | 320205
992121 | 320207
992378 | 320221
992397 | 320251
992435 | 320252
992468 | 320274
992546 | 320289
992718 | 320291
992743 | 320365
992794 | 320366
992797 | 320577
993005 | 320594
993013 | 320599
995509 | 320644
995510 | 320645
995550 | 320646
995589 | 320650
995624 | 320676
995626 | 320677
995627 | 320678
995629 | 320693
995632 | 320733
995641 | 320771
995652 | 320797
995655 | 320811
995663 | 320876
995672 | 320894
995673 | 330127
995675 | 330135
995686 | 330192
995689 | 330286
995691 | 330302
995695 | 340164
995813 | 340400
995818 | 341237
995825 | 350070
995826 | 350099
 | 350112
 | 350457
 | 352036
 | 352060
 | 352130
 | 352227
 | 352418
 | 352428
 | 352885
 | 360367
 | 360385
 | 360586
 | 360700
 | 360868
 | 360918
 | 370111
 | 370206
 | 370245
 | 414023
 | 414245
 | 414372
 | 414478
 | 414498
 | 414501
 | 414519
 | 414564
 | 421147
 | 421344
 | 421360
 | 421391
 | 421476
 | 421490
 | 421915
 | 430277
 | 430927
 | 431098
 | 431114
 | 431114
 | 431196
 | 431287
 | 431291
 | 431446
 | 431667
 | 440088
 | 440562
 | 440837
 | 441480
 | 442018
 | 450010
 | 450502
 | 450546
 | 450938
 | 451168
 | 451562
 | 451562
 | 460008
 | 460149
 | 460248
 | 460353
 | 460566
 | 460584
 | 460588
 | 460706
 | 490248
 | 490283
 | 490284
 | 490436
 | 510210
 | 510320
 | 510478
 | 510796
 | 510930
 | 511086
 | 511161
 | 511238
 | 511651
 | 511704
 | 511747
 | 511877
 | 520010
 | 520309
 | 520745
 | 521079
 | 521289
 | 521413
 | 521492
 | 521630
 | 521721
 | 522055
 | 522297
 | 522389
 | 522389
 | 523149
 | 523292
 | 523293
 | 523531
 | 523604
 | 523800
 | 610233
 | 610349
 | 610381
 | 610489
 | 610594
 | 610673
 | 610765
 | 610799
 | 610863
 | 610880
 | 610920
 | 620010
 | 620019
 | 620020
 | 620053
 | 620259
 | 620288
 | 620345
 | 620355
 | 620438
 | 620494
 | 620739
 | 621292
 | 630174
 | 630234
 | 630235
 | 630280
 | 630649
 | 630789
 | 630862
 | 630955
 | 630989
 | 631115
 | 631206
 | 631594
 | 631597
 | 631946
 | 632027
 | 640348
 | 640666
 | 640679
 | 700141
 | 700439
 | 700817
 | 701053
 | 701164
 | 701839
 | 702701
 | 702762
 | 702887
 | 702888
 | 702913
 | 703328
 | 703532
 | 703606
 | 704757
 | 704959
 | 705672
 | 705843
 | 706036
 | 706250
 | 706348
 | 800553
 | 800742
 | 800814
 | 800870
 | 801617
 | 801760
 | 801775
 | 801879
 | 801889
 | 801906
 | 801975
 | 801994
 | 802065
 | 802926
 | 802933
 | 803618
 | 805168
 | 805426
 | 805667
 | 805950
 | 805999
 | 807416
 | 807665
 | 807815
 | 807882
 | 902063
 | 903022
 | 903040
 | 904005
 | 909040
 | 909042
 | 909042
 | 909053
 | 910123
 | 911033
 | 912032
 | 914048
 | 915053
 | 916012
 | 916026
 | 916118
 | 916161
 | 922100
 | 926024
 | 929049
 | 931032
 | 932119
 | 933026
 | 934042
 | 935002
 | 935013
 | 937084
 | 938026
 | 939069
 | 941011
 | 942034
 | 942072
 | 943042
 | 945054
 | 950010
 | 950034
 | 960019
 | 961141
 | 980199
 | 980280
 | 980903
 | 980908
 | 981109
 | 981110
 | 981450
 | 981479
 | 981667
 | 981686
 | 981687
 | 981691
 | 981696
 | 981700
 | 981737
 | 981741
 | 981745
 | 990281
 | 990316
 | 990323
 | 990493
 | 990562
 | 990585
 | 991038
 | 991344
 | 991402
 | 991411
 | 991748
 | 992032
 | 992195
 | 992259
 | 992326
 | 992472
 | 992689
 | 992743
 | 992776
 | 992934
 | 993077
 | 993092
 | 993129
 | 993278
 | 993395
 | 993589
 | 993656
 | 993983
 | 994074
 | 994138
 | 994149
 | 994156
 | 994157
 | 994159
 | 994242
 | 994243
 | 994250
 | 994256
 | 994264
 | 994313
 | 994315
 | 994753
 | 994771
 | 995077
 | 995097
 | 995167
 | 995170
 | 995171
 | 995181
 | 995193
 | 995207
 | 995299
 | 995300
 | 995304
 | 995307
 | 995419
 | 995515
 | 995550
 | 995816
 | 2139043