Spreadsheet: 166489d1341600190-formula-problem-vlookup-combined-with-if-statement-excel-spreadheet-if-statement-with-vloolup
Sheet: pic tix % DS

Invoice Creation Date | Source | Invoice Number | [NAME] | Customer PO | Amount | Billing Specialist | Contract Type | [NAME]
2012-07-05 00:00:00 | E | 1154365 | 316839 | P4904W | 390.28 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154317 | 316884 | 13MB | 1540.64 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | E | 1154359 | 335640 | 64698 | 390.3 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154318 | 337092 | 1445 | 84478.1 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | E | 1154424 | 346985 | 500R101476 | 103.5 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154335 | 350116 | DJMS-11-A-0397 / CSO-27-0397 | 485 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | E | 1154333 | 350121 | DJMS-11-A-0397 / DJMS-12-61-M0090 | 6305 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | E | 1154334 | 350122 | DJMS-11-A-0397 / CSO-31-0397 | 970 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | E | 1154393 | 352244 |  | 73.52 | [NAME] | GOVT CC
2012-07-05 00:00:00 | E | 1154336 | 352507 | FA8629-10-A-2487-0129-3AA | 2932.32 | [NAME] | BPA GSA 6072P
2012-07-05 00:00:00 | E | 1154331 | 352694 | FA8629-10-A-2487-0127-3AL | 4133.1 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | E | 1154332 | 352697 | FA8629-10-A-2487-0127-3AM | 1982.6 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | E | 1154433 | 353335 | [NAME] | 175.2 | [NAME] | GSA #GS-21F-0110X
2012-07-05 00:00:00 | E | 1154428 | 354847 | W912PQ-12-F-0136 | 1013.88 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154325 | 354915 | FA8629-10-A-2487-0133-3AK | 401.6 | [NAME] | BPA GSA 0110X
2012-07-05 00:00:00 | E | 1153089 | 355685 | 14KY | 462471.72 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | E | 1154314 | 355874 | 10H4 | 1302.24 | [NAME] | FESWT #SPM8EG08D0016
2012-07-05 00:00:00 | E | 1154396 | 355886 |  | 37.2 | [NAME] | GOVT CC
2012-07-05 00:00:00 | E | 1154422 | 355964 | FGAKTX2927F | 85.9 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154430 | 355965 | FGAKTX2928F | 153 | [NAME] | GSA #GS-07F-6072P
2012-07-05 00:00:00 | E | 1154425 | 356126 | HSCG27-12-F-5PT480 | 34068.59 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154354 | 356402 | [PHONE] | 1038.26 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154423 | 356483 | 560R102353 | 21.77 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154419 | 356503 | NGL12-0338 | 4916.68 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154379 | 356514 | P120925 | 91.44 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154420 | 356614 | PCC-D-12-TR-0719 | 2960 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154370 | 356652 | PO-12-1700 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154366 | 356653 | PO-12-1687 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154371 | 356664 | PO-12-1701 | 36.27 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154372 | 356667 | PO-12-1702 | 36.27 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154372 | 356667 | PO-12-1702 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154373 | 356673 | PO-12-1703 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154373 | 356673 | PO-12-1703 | 36.27 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154367 | 356676 | PO-12-1696 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154378 | 356678 | PO-12-1760 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154375 | 356680 | PO-12-1756 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154376 | 356685 | PO-12-1757 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154374 | 356687 | PO-12-1754 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154412 | 356700 | FGAKUH8168F | 254.82 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154353 | 356713 | [NAME] | 1865.5 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154353 | 356713 | [NAME] | 739.9 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154429 | 356714 |  | 906.8000000000001 | [NAME] | GSA #GS-07F-6072P
2012-07-05 00:00:00 | E | 1154387 | 356731 | A2C203521 | 18496.38 | [NAME] | FEDBID
2012-07-05 00:00:00 | E | 1154434 | 356788 | [NAME] | 126.96 | [NAME] | GSA #GS-21F-0110X
2012-07-05 00:00:00 | E | 1154352 | 356793 | PO-12-1782 | 36.27 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154352 | 356793 | PO-12-1782 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154377 | 356892 | PO-12-1759 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154369 | 356895 | PO-12-1699 | 50.58 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154369 | 356895 | PO-12-1699 | 36.2 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | E | 1154421 | 356960 | FGAKTZ7609F | 708.26 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | E | 1154400 | 356992 |  | 1934.2 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154435 | 247833 | HQ0034-08-D-1003/0274-0300 | 495 | [NAME] | IDIQ
2012-07-05 00:00:00 | I | 1154397 | 325328 |  | 43.75 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154343 | 332058 | GBW.3110-069_PO#01 | 3562.5 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154389 | 332592 | [PHONE] | 500 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154398 | 335672 |  | 56.25 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154351 | 341491 | 9356.0001.01-0065 | 232 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154355 | 341867 | 15892 | 100 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154319 | 344467 | 14BF | 93436.48 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154320 | 345672 | 14CN | 50343.58 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154327 | 346140 | INL6S00214-IQ-GARY FRY | 151.96 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | I | 1154328 | 346141 | INL6S00214-IQ-RUSSELL SMITH | 46 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | I | 1154516 | 347293 | SAMPLE | 1839.46 | [NAME] | SAMPLE
2012-07-05 00:00:00 | I | 1154321 | 348176 | 14E3 | 29892.28 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154356 | 348456 | 08ESM488943 | 572.92 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154515 | 348527 | W912PQ-12-P-0051 | 3174.36 | [NAME] | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | I | 1154417 | 349635 |  | 116.8 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154342 | 349870 | LG40039287 | 690.7 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154401 | 349878 |  | 1068.5 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154437 | 349941 | H92244-12-P-0336 | 157.3 | [NAME] | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | I | 1154315 | 350060 | 14FD | 1198.35 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154347 | 350174 | PO12-00217 | 25 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154362 | 350439 | 237GA2 | 957.5600000000001 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154346 | 351019 | PO12-00179 | 9775.92 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154432 | 351245 | P173984 | 2687.92 | [NAME] | GSA #GS-07F-6072P
2012-07-05 00:00:00 | I | 1154345 | 351280 | ALCO BANK TRANSFER - 1 | 6517.72 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154344 | 351309 | 2362 | 2727 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154360 | 351491 | VA-300311 | 2433.4 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154512 | 351547 | PO12-289699 | 8625 | [NAME] | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | I | 1154426 | 351682 | 40010385/01 | 117.88 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154517 | 352604 |  | 60720 | [NAME] | SAMPLE
2012-07-05 00:00:00 | I | 1154416 | 352651 | [NAME] | 295.9 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154337 | 353089 | FA5215-08-A-7000-2014 | 1271.16 | [NAME] | BPA-GOVT
2012-07-05 00:00:00 | I | 1154514 | 353209 | 246022 | 374 | [NAME] | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | I | 1154407 | 353212 |  | 180 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154427 | 353265 | [PHONE] | 163.95 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154326 | 353306 | FA8629-10-A-2487-0135-3AB | 401.6 | [NAME] | BPA GSA 0110X
2012-07-05 00:00:00 | I | 1154330 | 353307 | FA8629-10-A-2487-0135-3AA | 1099.62 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | I | 1154329 | 353333 | FA8629-10-A-2487-0135-2AL | 789.44 | [NAME] | BPA GSA 5965P
2012-07-05 00:00:00 | I | 1154410 | 353599 |  | 1680 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154348 | 353747 | PO12-00246 | 2000.3 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154357 | 353770 | 23233 | 1160.6 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154341 | 353781 | INL6P05149 | 1669.77 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154391 | 353975 |  | 625.5 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154388 | 354145 | N5526221380315 | 277.81 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154350 | 354192 | 9356-0082 | 75.60000000000001 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154316 | 354196 | 104W | 160.64 | [NAME] | FESNE #SPM8EG08D0005
2012-07-05 00:00:00 | I | 1154316 | 354196 | 104W | 1973.43 | [NAME] | FESNE #SPM8EG08D0005
2012-07-05 00:00:00 | I | 1154349 | 354217 | 9356-0080_REVISED | 104.6 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154395 | 354320 |  | 2630.32 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154390 | 354554 |  | 2999.2 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154418 | 354678 | FGAKUD4557F | 5178.25 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154364 | 354679 | 411420 | 9879.47 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154513 | 354704 | PO12-291375 | 1822.5 | [NAME] | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | I | 1154436 | 354833 | 12007985-00 | 1457.08 | [NAME] | NY HIRE19745-PC61966
2012-07-05 00:00:00 | I | 1154322 | 354892 | 14KJ | 1650.96 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154380 | 354913 | VF-1027 | 1935.96 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154409 | 355099 |  | 62.7 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154402 | 355166 |  | 22 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154403 | 355181 |  | 22 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154404 | 355185 |  | 22 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154405 | 355188 |  | 22 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154406 | 355190 |  | 22 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154339 | 355279 | VF-1031 | 1006.25 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154340 | 355284 | 5523 | 2012.5 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154511 | 355434 |  | 66 | [NAME] | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | I | 1154381 | 355622 | 2471 | 215.1 | [NAME] | EMALL GSA BPA SPM7W108DE055
2012-07-05 00:00:00 | I | 1154358 | 355662 | 694101 | 689.92 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154408 | 355677 |  | 400 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154431 | 355773 | 694151 | 526.5 | [NAME] | GSA #GS-07F-6072P
2012-07-05 00:00:00 | I | 1154399 | 355905 |  | 800.36 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154392 | 355910 |  | 95.92 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154411 | 355914 | 133509 | 643.2 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154363 | 355976 | ESM613 | 69.32000000000001 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154324 | 356405 | 14LK | 730.89 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154323 | 356410 | 14LG | 1391.28 | [NAME] | TLSNFPBID #SPM8EJ09D0017
2012-07-05 00:00:00 | I | 1154423 | 356483 | 560R102353 | 58.74 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154413 | 356487 | FGAKUG2606F | 231.84 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154419 | 356503 | NGL12-0338 | 736.65 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154415 | 356512 | FGAKUG3416F | 1385.07 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154361 | 356515 | [PHONE] | 235.66 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154394 | 356527 |  | 88 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154394 | 356527 |  | 22 | [NAME] | GOVT CC
2012-07-05 00:00:00 | I | 1154338 | 356629 | H92244-11-A-0005-0026 | 14079.45 | [NAME] | BPA-GOVT
2012-07-05 00:00:00 | I | 1154368 | 356647 | PO-12-1698 | 31.27 | [NAME] | COMMERCIAL PO
2012-07-05 00:00:00 | I | 1154414 | 356792 | FGAKUG8316F | 84.64 | [NAME] | GSA #GS-07F-5965P
2012-07-05 00:00:00 | I | 1154438 | 357020 | H92244-12-P-0412 | 6012.5 | [NAME] | OPEN MRKT GOVT CONTRACT