Spreadsheet: 99234d1297943733-why-doesnt-this-vlookup-work-test
Sheet: Profit and Cost Centres

Company Code | Profit Center | Cost Center
1180 | 9080010109 | 9080010109
1100 | 9080010110 | 9080010110
1130 | 9080010111 | 9080010111
1135 | 9080010116 | 9080010116
1174 | 9080010192 | 9080010192
1176 | 9080010193 | 9080010193
1137 | 9080010197 | 9080010197
1005 | 9080010199 | 9080010199
3033 | 9080035132
1190 | 9080015400 | 9080015400
2041 | 9080016000 | 9080016000
6031 | 9080018514 | 9080018514
6127 | 9080018700 | 9080018700
6025 | 9080018800 | 9080018800
6060 | 9080019300 | 9080019300
7016 | 9080030800 | 9080030800
3048 | 9080033221 | 9080033221
3034 | 9080035114 | 9080035114
8077 | 9080070406 | 9080070406
2006 | 9080035100 | 9080035100
3010 | 9080035102 | 9080035102
3019 | 9080035103 | 9080035103
6072 | 9008061000
3031 | 9050035152 | 9050035152
3044 | 9060039121 | 9060039121
6126 | 9060018508 | 9060018508
3000 | 9080035105 | 9080035105
3023 | 9080035107
3022 | 9080035106 | 9080035106
3029 | 9080035118 | 9080035118
7116 | 9080036003 | 9080036003
8072 | 9080070402 | 9080070402
8073 | 9080070403 | 9080070403
3025 | 9080035108 | 9080035108
3026 | 9080035109 | 9080035109
3021 | 9080035116 | 9080035116
3024 | 9080035117 | 9080035117
1300 | 9080035121 | 9080035121
1301 | 9080035122 | 9080035122
1303 | 9080035124 | 9080035124
1304 | 9080035125 | 9080035125
3022 | 9080035140 | 9080035140
3022 | 9080035145 | 9080035145
3010 | 9080035187 | 9080035187
1202 | 9080035501 | 9080035501
7115 | 9080036001 | 9080036001
8115 | 9080036002 | 9080036002
3300 | 9080036004 | 9080036004
3081 | 9080036500 | 9080036500
7021 | 9080036700 | 9080036700
7020 | 9080036701 | 9080036701
7019 | 9080036702 | 9080036702
2020 | 9080038701 | 9080038701
3200 | 9080038705 | 9080038705
3210 | 9080038706 | 9080038706
3212 | 9080038708 | 9080038708
3143 | 9080039100 | 9080039100
3040 | 9080039101 | 9080039101
3041 | 9080039102 | 9080039102
3046 | 9080039106 | 9080039106
3049 | 9080039107 | 9080039107
7011 | 9080040101 | 9080040101
7010 | 9080040102 | 9080040102
2002 | 9080050000 | 9080050000
5008 | 9080050080 | 9080050080
2005 | 9080050200 | 9080050200
2010 | 9080050201 | 9080050201
5011 | 9080050202 | 9080050202
5016 | 9080051200 | 9080051200
5025 | 9080051201 | 9080051201
5019 | 9080052200 | 9080052200
5020 | 9080052201 | 9080052201
5024 | 9080052202 | 9080052202
7031 | 9080052672 | 9080052672
5075 | 9080052801 | 9080052801
5017 | 9080053400 | 9080053400
5015 | 9080053401 | 9080053401
5026 | 9080053600 | 9080053600
5040 | 9080053900 | 9080053900
5021 | 9080054400 | 9080054400
7102 | 9080055001 | 9080055001
7103 | 9080055043 | 9080055043
5051 | 9080056000 | 9080056000
5023 | 9080056200 | 9080056200
2011 | 9080056600 | 9080056600
5035 | 9080056601 | 9080056601
5014 | 9080056602 | 9080056602
5036 | 9080056603 | 9080056603
5037 | 9080056604 | 9080056604
5038 | 9080056605 | 9080056605
5022 | 9080058000 | 9080058000
5045 | 9080059073 | 9080059073
6055 | 9080060000 | 9080060000
6066 | 9080060200 | 9080060200
6045 | 9080060403 | 9080060403
6043 | 9080060420 | 9080060420
6012 | 9080060421 | 9080060421
2061 | 9080060447 | 9080060447
6070 | 9080060801 | 9080060801
6102 | 9080062801 | 9080062801
8070 | 9080070400 | 9080070400
8071 | 9080070401 | 9080070401
8053 | 9080070404 | 9080070404
8071 | 9080070424 | 9080070424
8071 | 9080070425 | 9080070425
8071 | 9080070426 | 9080070426
7080 | 9080070800 | 9080070800
8090 | 9080071000 | 9080071000
8090 | 9080071020 | 9080071020
8038 | 9080071801 | 9080071801
7072 | 9080073800 | 9080073800
7075 | 9080073801 | 9080073801
7073 | 9080073802 | 9080073802
8050 | 9080074000 | 9080074000
8051 | 9080074001 | 9080074001
8052 | 9080074002 | 9080074002
8051 | 9080074020 | 9080074020
8051 | 9080074022 | 9080074022
2003 | 9080075412 | 9080075412
8020 | 9080076200 | 9080076200
8021 | 9080076201 | 9080076201
8023 | 9080076202 | 9080076202
8024 | 9080076203 | 9080076203
8023 | 9080076225 | 9080076225
7085 | 9080077200 | 9080077200
8075 | 9080078000 | 9080078000
7049 | 9080079055 | 9080079055
8065 | 9080079800 | 9080079800
8066 | 9080079801 | 9080079801
2009 | 9080080200 | 9080080200
7022 | 9080080201 | 9080080201
7015 | 9080080401 | 9080080401
8060 | 9080080800 | 9080080800
8061 | 9080080801 | 9080080801
8062 | 9080080802 | 9080080802
8206 | 9080081201 | 9080081201
8026 | 9080082200 | 9080082200
7030 | 9080083000 | 9080083000
7029 | 9080083077 | 9080083077
8045 | 9080083401 | 9080083401
7025 | 9080084000 | 9080084000