Spreadsheet: 118066d1313419360-vlookup-if-statement-giving-strange-values-21-screwed-up-vlookup-and-if-formula
Sheet: INPUT

 |  |  |  |  | Store # |  | Co. Code
 |  |  | 6268 |  | 6268 |  | Not Reqd
 |  |  | 6273 |  | 6273 |  | Not Reqd
 |  |  | 6274 |  | 6274 |  | Not Reqd
 |  |  | 6276 |  | 6276 |  | Not Reqd
 |  |  | 6277 |  | 6277 |  | Not Reqd
 |  |  | 6281 |  | 6281 |  | Not Reqd
 |  |  | 6283 |  | 6283 |  | Not Reqd
 |  |  | 6284 |  | 6284 |  | Not Reqd
 |  |  | 6286 |  | 6286 |  | Not Reqd
 |  |  | 6288 |  | 6288 |  | Not Reqd
 |  |  | 6290 |  | 6290 |  | Not Reqd
 |  |  | 6292 |  | 6292 |  | Not Reqd
 |  |  | 6293 |  | 6293 |  | Not Reqd
 |  |  | 6296 |  | 6296 |  | Not Reqd
 |  |  | 6298 |  | 6298 |  | Not Reqd
 |  |  | 6299 |  | 6299 |  | Not Reqd
 |  |  | 6301 |  | 6301 |  | Not Reqd
 |  |  | 6302 |  | 6302 |  | Not Reqd
 |  |  | 6304 |  | 6304 |  | Not Reqd
 |  |  | 6305 |  | 6305 |  | Not Reqd
 |  |  | 6309 |  | 6309 |  | Not Reqd
 |  |  | 6310 |  | 6310 |  | Not Reqd
 |  |  | 6313 |  | 6313 |  | Not Reqd
 |  |  | 6315 |  | 6315 |  | Not Reqd
 |  |  | 6316 |  | 6316 |  | Not Reqd
 |  |  | 6317 |  | 6317 |  | Not Reqd
 |  |  | 6318 |  | 6318 |  | Not Reqd
 |  |  | 6319 |  | 6319 |  | Not Reqd
 |  |  | 6320 |  | 6320 |  | Not Reqd
 |  |  | 6322 |  | 6322 |  | Not Reqd
 |  |  | 6329 |  | 6329 |  | Not Reqd
 |  |  | 6332 |  | 6332 |  | Not Reqd
 |  |  | 6334 |  | 6334 |  | Not Reqd
 |  |  | 6335 |  | 6335 |  | Not Reqd
 |  |  | 6336 |  | 6336 |  | Not Reqd
 |  |  | 6338 |  | 6338 |  | Not Reqd
 |  |  | 6339 |  | 6339 |  | Not Reqd
 |  |  | 6340 |  | 6340 |  | Not Reqd
 |  |  | 6341 |  | 6341 |  | Not Reqd
 |  |  | 6342 |  | 6342 |  | Not Reqd
 |  |  | 6343 |  | 6343 |  | Not Reqd
 |  |  | 6347 |  | 6347 |  | Not Reqd
 |  |  | 6354 |  | 6354 |  | Not Reqd
 |  |  | 6358 |  | 6358 |  | Not Reqd
 |  |  | 6359 |  | 6359 |  | Not Reqd
 |  |  | 6360 |  | 6360 |  | Not Reqd
 |  |  | 6361 |  | 6361 |  | Not Reqd
 |  |  | 6362 |  | 6362 |  | Not Reqd
 |  |  | 6363 |  | 6363 |  | Not Reqd
 |  |  | 6364 |  | 6364 |  | Not Reqd
 |  |  | 6366 |  | 6366 |  | Not Reqd
 |  |  | 6372 |  | 6372 |  | Not Reqd
 |  |  | 6374 |  | 6374 |  | Not Reqd
 |  |  | 6377 |  | 6377 |  | Not Reqd
 |  |  | 6378 |  | 6378 |  | Not Reqd
 |  |  | 6379 |  | 6379 |  | Not Reqd
 |  |  | 6381 |  | 6381 |  | Not Reqd
 |  |  | 6385 |  | 6385 |  | Not Reqd
 |  |  | 6386 |  | 6386 |  | Not Reqd
 |  |  | 6387 |  | 6387 |  | Not Reqd
 |  |  | 6389 |  | 6389 |  | Not Reqd
 |  |  | 6390 |  | 6390 |  | Not Reqd
 |  |  | 6391 |  | 6391 |  | Not Reqd
 |  |  | 6393 |  | 6393 |  | Not Reqd
 |  |  | 6394 |  | 6394 |  | Not Reqd
 |  |  | 6395 |  | 6395 |  | Not Reqd
 |  |  | 6396 |  | 6396 |  | Not Reqd
 |  |  | 6401 |  | 6401 |  | Not Reqd
 |  |  | 6402 |  | 6402 |  | Not Reqd
 |  |  | 6403 |  | 6403 |  | Not Reqd
 |  |  | 6404 |  | 6404 |  | Not Reqd
 |  |  | 6405 |  | 6405 |  | Not Reqd
 |  |  | 6406 |  | 6406 |  | Not Reqd
 |  |  | 6407 |  | 6407 |  | Not Reqd
 |  |  | 6408 |  | 6408 |  | Not Reqd
 |  |  | 6409 |  | 6409 |  | Not Reqd
 |  |  | 6413 |  | 6413 |  | Not Reqd
 |  |  | 6414 |  | 6414 |  | Not Reqd
 |  |  | 6415 |  | 6415 |  | Not Reqd
 |  |  | 6417 |  | 6417 |  | Not Reqd
 |  |  | 6418 |  | 6418 |  | Not Reqd
 |  |  | 6419 |  | 6419 |  | Not Reqd
 |  |  | 6420 |  | 6420 |  | Not Reqd
 |  |  | 6421 |  | 6421 |  | Not Reqd
 |  |  | 6422 |  | 6422 |  | Not Reqd
 |  |  | 6426 |  | 6426 |  | Not Reqd
 |  |  | 6427 |  | 6427 |  | Not Reqd
 |  |  | 6428 |  | 6428 |  | Not Reqd
 |  |  | 6429 |  | 6429 |  | Not Reqd
 |  |  | 6431 |  | 6431 |  | Not Reqd
 |  |  | 6435 |  | 6435 |  | Not Reqd
 |  |  | 6436 |  | 6436 |  | Not Reqd
 |  |  | 6438 |  | 6438 |  | Not Reqd
 |  |  | 6439 |  | 6439 |  | Not Reqd
 |  |  | 6440 |  | 6440 |  | Not Reqd
 |  |  | 6441 |  | 6441 |  | Not Reqd
 |  |  | 6442 |  | 6442 |  | Not Reqd
 |  |  | 6443 |  | 6443 |  | Not Reqd
 |  |  | 6444 |  | 6444 |  | Not Reqd
 |  |  | 6446 |  | 6446 |  | Not Reqd
 |  |  | 6447 |  | 6447 |  | Not Reqd
 |  |  | 7015 |  | 7015 |  | Not Reqd
 |  |  | 7016 |  | 7016 |  | Not Reqd
 |  |  | 7025 |  | 7025 |  | Not Reqd
 |  |  | 7046 |  | 7046 |  | Not Reqd
 |  |  | 7072 |  | 7072 |  | Not Reqd
 |  |  | 7084 |  | 7084 |  | Not Reqd
 |  |  | 7086 |  | 7086 |  | Not Reqd
 |  |  | 7102 |  | 7102 |  | Not Reqd
 |  |  | 7106 |  | 7106 |  | Not Reqd
 |  |  | 7118 |  | 7118 |  | Not Reqd
 |  |  | 7119 |  | 7119 |  | Not Reqd
 |  |  | 7121 |  | 7121 |  | Not Reqd
 |  |  | 7123 |  | 7123 |  | Not Reqd
 |  |  | 7129 |  | 7129 |  | Not Reqd
 |  |  | 7131 |  | 7131 |  | Not Reqd
 |  |  | 7135 |  | 7135 |  | Not Reqd
 |  |  | 7138 |  | 7138 |  | Not Reqd
 |  |  | 7142 |  | 7142 |  | Not Reqd
 |  |  | 7143 |  | 7143 |  | Not Reqd
 |  |  | 7151 |  | 7151 |  | Not Reqd
 |  |  | 7153 |  | 7153 |  | Not Reqd
 |  |  | 7170 |  | 7170 |  | Not Reqd
 |  |  | 7178 |  | 7178 |  | Not Reqd
 |  |  | 7181 |  | 7181 |  | Not Reqd
 |  |  | 7184 |  | 7184 |  | Not Reqd
 |  |  | 7185 |  | 7185 |  | Not Reqd
 |  |  | 7187 |  | 7187 |  | Not Reqd
 |  |  | 7193 |  | 7193 |  | Not Reqd