Spreadsheet: 220232d1363103485-if-and-vlookup-vlookup-pulls-first-number-sample1
Sheet: AWC FY13 Sept

 |  |  |  |  |  |  |  |  |  |  |  |  | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 | Sept '13 |  | Sept '13
 | IW JOB # | CAMPAIGN | Program | Effort | NWF Cost | NWF Cost Extended | FY13 March-Aug Counts | FINAL RE-ORDER QTY | ReOrder Point | Item | Stock Codes | Control / Test | Starting Inventory |  | E1 P1 Usage | E1 P1 Cost | [NAME] | E1 P2 Cost | E1 P3 Usage | E1 P3 Cost | E1 P4 Usage | E1 P4 Cost |  | E1.5 P1 Usage | E1.5 P1 Cost | E1.5P2 Usage | E1.5 P2 Cost | E1.5 P3 Usage | E1.5 P3 Cost | E1.5 P4 Usage | E1.5 P4 Usage |  | [NAME] | [NAME] | [NAME] | E2  P2 Cost | [NAME] | E2 P3 Cost | E2 P4 Usage | E2 P4 Usage |  | E3 P1 Usage | E3 P1 Cost | E3 P2 Usage | E3  P2 Cost | E3 P3 Usage | E3 P3 Cost | E3 P4 Usage | E3 P4 Usage |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | E4 P3 Cost | E4 P4 Usage | E4 P4 Cost | E4 P5 Usage | E4 P45 Cost |  | E5 P1 Usage | E5 P1 Cost | E5 [NAME] | E5 P2 Cost | E5 P3 Usage | E5 P3 Cost | E5 P4 Usage | E5 P4 Cost |  | E6 P1 Usage | E6 P1 Cost | [NAME] | E6 P2 Cost | E6 P3 Usage | E6 P3 Cost | E6 P4 Usage | E6 P4 Cost |  | E7 P1 Usage | E7 P1 Cost | [NAME] | E7 P2 Cost | E7 P3 Usage | E7 P3 Cost | E7 P4 Usage | E7 P4 Cost |  | E8 P1 Usage | E8 P1 Cost | [NAME] | [NAME] | E8 P3 Usage | E8 P3 Cost |  | E9 P1 Usage | E9 P1 Cost | E9 P2 Usage | E9 P2 Cost | E9 P2 Usage | E9 P2 Cost |  | Ending Inventory
C |  | M-A 2013 | AWC | E1 | 6.67 |  | 262055 | 269917 | 125778 | [NAME] | [NAME] | C
C |  | M-A 2013 | AWC | E1 | 6.67 |  | 262055 | 231364 | 125778 | [NAME] | A3465 | C
C |  | M-A 2013 | AWC | E1 | 16.22 |  | 14633 | 15072 | TEST | OSE | B3384 | T
C |  | M-A 2013 | AWC | E1 | 16.22 |  | 247422 | 209049 | 125778 | OSE | B3044 | C
C |  | M-A 2013 | AWC | E1 | 9.95 |  | 262055 | 273422 | 125778 | RE | C2923 | C
C |  | M-A 2013 | AWC | E1 | 47.48 |  | 262055 | 215813 | 125778 | Form | F4047 | C
C |  | M-A 2013 | AWC | E1 | 11.9 |  | 262055 | 234661 | 125778 | Letter | G3505 | C
C |  | M-A 2013 | AWC | E1.5 | 16.22 |  | 11136 | 11470 | TEST | OSE | B3376 | T
C |  | M-A 2013 | AWC | E1.5 | 13.59 |  | 256040 | 172530 | 133587 | OSE | B3046 | C
C |  | M-A 2013 | AWC | E1.5 | 9.95 |  | 11136 | 12250 | TEST | RE | C3061 | T
C |  | M-A 2013 | AWC | E1.5 | 9.07 |  | 256040 | 212683 | 133587 | RE | C2924 | C
C |  | M-A 2013 | AWC | E1.5 | 13.37 |  | 256040 | 172906 | 133587 | Form | F4048 | C
C |  | M-A 2013 | AWC | E1.5 | 13.37 |  | 11136 | 12806 | TEST | Form | F4043 | T
C |  | M-A 2013 | AWC | E1.5 | 11.9 |  | 11136 | 12250 | TEST | Letter | G3568 | T
C |  | M-A 2013 | AWC | E2 | 13.59 |  | 272034 | 157853 | 136017 | OSE | B3045 | C
C |  | M-A 2013 | AWC | E2 | 9.07 |  | 272034 | 199157 | 136017 | RE | C2924 | C
C |  | M-A 2013 | AWC | E2 | 13.37 |  | 272034 | 236109 | 136017 | Form | F4054 | C
C |  | M-A 2013 | AWC | E2 | 11.9 |  | 272034 | 216292 | 136017 | Letter | G3504 | C
C |  | M-A 2013 | AWC | E3 | 6.67 |  | 254948 | 218158 | 130719 | [NAME] | A3390 | C
C |  | M-A 2013 | AWC | E3 | 21 |  | 17190 | 17706 | TEST | OSE | [NAME] | T
C |  | M-A 2013 | AWC | E3 | 21 |  | 237758 | 204853 | 130719 | OSE | B3381 | C
C |  | M-A 2013 | AWC | E3 | 10.52 |  | 254948 | 257102 | 130719 | RE | C3063 | C
C |  | M-A 2013 | AWC | E3 | 13.37 |  | 17190 | 19769 | TEST | Form | F4055 | T
C |  | M-A 2013 | AWC | E3 | 127.89 |  | 237758 | 250978 | 130719 | Form | F4049 | C
C |  | M-A 2013 | AWC | E3 | 11.9 |  | 237758 | 187870 | 130719 | Letter | [NAME] | C
C |  | M-A 2013 | AWC | E3 | 11.9 |  | 17190 | 17706 | TEST | Letter | G3655 | T
C |  | M-A 2013 | AWC | E4 | 6.67 |  | 255381 | 206189 | 127692 | [NAME] | A3457 | C
C |  | M-A 2013 | AWC | E4 | 13.59 |  | 255381 | 174928 | 127692 | OSE | B3221 | C
C |  | M-A 2013 | AWC | E4 | 9.07 |  | 255381 | 202004 | 127692 | RE | C2924 | C
C |  | M-A 2013 | AWC | E4 | 13.37 |  | 255381 | 197916 | 127692 | Form | F4050 | C
C |  | M-A 2013 | AWC | E5 | 6.67 |  | 277063 | 246165 | 138801 | [NAME] | [NAME] | C
C |  | M-A 2013 | AWC | E5 | 16.22 |  | 277063 | 244802 | 138801 | OSE | B3382 | C
C |  | M-A 2013 | AWC | E5 | 9.95 |  | 277063 | 228880 | 138801 | RE | C2923 | C
C |  | M-A 2013 | AWC | E5 | 13.37 |  | 277063 | 269679 | 138801 | Form | F4051 | C
C |  | M-A 2013 | AWC | E5 | 11.9 |  | 277063 | 259946 | 138801 | Letter | [NAME] | C
C |  | M-A 2013 | AWC | E6 | 16.22 |  | 270256 | 234356 | 131883 | OSE | B3273 | C
C |  | M-A 2013 | AWC | E6 | 9.95 |  | 270256 | 226869 | 131883 | RE | C2923 | C
C |  | M-A 2013 | AWC | E6 | 13.37 |  | 270256 | 255997 | 131883 | Form | F3977 | C
C |  | M-A 2013 | AWC | E6 | 11.9 |  | 270256 | 239677 | 131883 | Letter | G3502 | C
C |  | M-A 2013 | AWC | E6 | 35 |  | 270256 | 250000 | 131883 | Decal | None | C
C |  | M-A 2013 | AWC | E7 | 21 |  | 230926 | 197567 | 115464 | OSE | B3383 | C
C |  | M-A 2013 | AWC | E7 | 10.52 |  | 230926 | 187360 | 115464 | RE | C3063 | C
C |  | M-A 2013 | AWC | E7 | 127.89 |  | 230926 | 238416 | 115464 | Form | F4052 | C
C |  | M-A 2013 | AWC | E7 | 22.19 |  | 230926 | 212143 | 115464 | Letter | G3502 | C
C |  | M-A 2013 | AWC | E8 | 6.67 |  | 209233 | 177597 | 104616 | [NAME] | A3393 | C
C |  | M-A 2013 | AWC | E8 | 18.34 |  | 209233 | 191910 | 104616 | OSE | B3051 | C
C |  | M-A 2013 | AWC | E8 | 12.46 |  | 209233 | 191833 | 104616 | RE | C2926 | C
C |  | M-A 2013 | AWC | E8 | 13.37 |  | 209233 | 196560 | 104616 | Form | F4053 | C
C |  | M-A 2013 | AWC | E8 | 11.9 |  | 209233 | 178685 | 104616 | Letter | G3500 | C
C |  | M-A 2013 | AWC | E9 | 6.67 |  | 195414 | 57526 | 97707 | [NAME] | A3392 | C
C |  | M-A 2013 | AWC | E9 | 21 |  | 195414 | 140989 | 97707 | OSE | B3383 | C
C |  | M-A 2013 | AWC | E9 | 10.52 |  | 195414 | 130782 | 97707 | RE | C3063 | C
C |  | M-A 2013 | AWC | E9 | 127.89 |  | 195414 | 177580 | 97707 | Form | F4052 | C
C |  | M-A 2013 | AWC | E9 | 22.19 |  | 195414 | 155565 | 97707 | Letter | G3501 | C
B |  | S-F 2013 | AWC | E1 | 20.15 |  |  |  |  | OSE | B3044 | C
B |  | S-F 2013 | AWC | E1.5 | 13.06 |  |  |  |  | OSE | B3046 | C
B |  | S-F 2013 | AWC | E2 | 13.06 |  |  |  |  | OSE | B3045 | C
B |  | S-F 2013 | AWC | E3 | 21.55 |  |  |  |  | OSE | B3215 | C
B |  | S-F 2013 | AWC | E4 | 13.06 |  |  |  |  | OSE | B3221 | C
B |  | S-F 2013 | AWC | E5 | 20.15 |  |  |  |  | OSE | B3217 | C
B |  | S-F 2013 | AWC | E6 | 13.06 |  |  |  |  | OSE | B3273 | C
B |  | S-F 2013 | AWC | E7 | 21.55 |  |  |  |  | OSE | B3216 | C
B |  | S-F 2013 | AWC | E8 | 18.95 |  |  |  |  | OSE | B3051 | C
B |  | S-F 2013 | AWC | E9 | 21.55 |  |  |  |  | OSE | B3216 | C
B |  | S-F 2013 | AWC | E1 | 11 |  |  |  |  | Letter | G3568 | C
B |  | S-F 2013 | AWC | E2 | 9.31 |  |  |  |  | Letter | G3571 | C
B |  | S-F 2013 | AWC | E3 | 9.31 |  |  |  |  | Letter | G3577 | C
B |  | S-F 2013 | AWC | E5 | 5.15 |  |  |  |  | Letter | G3570 | C
B |  | S-F 2013 | AWC | E6 | 11 |  |  |  |  | Letter | G3569 | C
B |  | S-F 2013 | AWC | E7 | 16.01 |  |  |  |  | Letter | G3502 | C
B |  | S-F 2013 | AWC | E8 | 9.31 |  |  |  |  | Letter | [NAME] | C
B |  | S-F 2013 | AWC | E9 | 16.01 |  |  |  |  | Letter | G3502 | C
B |  | S-F 2013 | AWC | E1 | 77.9 |  |  |  |  | Form | F3975 | C | 258500
B |  | S-F 2013 | AWC | E1.5 | 5.15 |  |  |  |  | Form | F3970 | C | 345284
B |  | S-F 2013 | AWC | E2 | 5.15 |  |  |  |  | Form | F3971 | C | 289798
B |  | S-F 2013 | AWC | E3 | 103.3 |  |  |  |  | Form | F3972 | C
B |  | S-F 2013 | AWC | E4 | 12.85 |  |  |  |  | Form | F3973 | C
B |  | S-F 2013 | AWC | E5 | 6.54 |  |  |  |  | Form | F3974 | C
B |  | S-F 2013 | AWC | E6 | 27.3 |  |  |  |  | Form | F3977 | C
B |  | S-F 2013 | AWC | E7 | 79 |  |  |  |  | Form | F3976 | C
B |  | S-F 2013 | AWC | E8 | 7.78 |  |  |  |  | Form | F3882 | C
B |  | S-F 2013 | AWC | E9 | 79 |  |  |  |  | Form | F3976 | C
B |  | S-F 2013 | AWC | E1 | 4.7 |  |  |  |  | [NAME] | A3391 | C
B |  | S-F 2013 | AWC | E1 | 4.7 |  |  |  |  | [NAME] | [NAME] | C
B |  | S-F 2013 | AWC | E3 | 4.7 |  |  |  |  | [NAME] | A3390 | C
B |  | S-F 2013 | AWC | E4 | 4.7 |  |  |  |  | [NAME] | A3260 | C
B |  | S-F 2013 | AWC | E5 | 5 |  |  |  |  | [NAME] | [NAME] | C
B |  | S-F 2013 | AWC | E8 | 16.19 |  |  |  |  | [NAME] | A3393 | C
B |  | S-F 2013 | AWC | E9 | 4.7 |  |  |  |  | [NAME] | A3392 | C
B |  | S-F 2013 | AWC | E1 | 8.83 |  |  |  |  | RE | C2923 | C
B |  | S-F 2013 | AWC | E1.5 | 7.9 |  |  |  |  | RE | C2924 | C
B |  | S-F 2013 | AWC | E2 | 7.9 |  |  |  |  | RE | C2924 | C
B |  | S-F 2013 | AWC | E3 | 11.98 |  |  |  |  | RE | C2925 | C
B |  | S-F 2013 | AWC | E4 | 7.9 |  |  |  |  | RE | C2924 | C
B |  | S-F 2013 | AWC | E5 | 8.83 |  |  |  |  | RE | C2923 | C
B |  | S-F 2013 | AWC | E6 | 8.83 |  |  |  |  | RE | C2923 | C
B |  | S-F 2013 | AWC | E7 | 11.98 |  |  |  |  | RE | C2925 | C
B |  | S-F 2013 | AWC | E8 | 12.06 |  |  |  |  | RE | C2926 | C
B |  | S-F 2013 | AWC | E9 | 11.98 |  |  |  |  | RE | C2925 | C
B |  | S-F 2013 | AWC | E6 | 27.93 |  |  |  |  | Decal | Decal | C
A |  | M-A 2012 | AWC | E1 | 19.55 |  |  |  |  | OSE | B3044 | C
A |  | M-A 2012 | AWC | E1.5 | 15.11 |  |  |  |  | OSE | B3046 | C
A |  | M-A 2012 | AWC | E2 | 15.11 |  |  |  |  | OSE | B3045 | C
A |  | M-A 2012 | AWC | E3 | 24.25 |  |  |  |  | OSE | B3215 | C
A |  | M-A 2012 | AWC | E4 | 14.93 |  |  |  |  | OSE | B3221 | C
A |  | M-A 2012 | AWC | E5 | 19.55 |  |  |  |  | OSE | B3217 | C
A |  | M-A 2012 | AWC | E6 | 15.3 |  |  |  |  | OSE | B3273 | C
A |  | M-A 2012 | AWC | E7 | 24.25 |  |  |  |  | OSE | B3216 | C
A |  | M-A 2012 | AWC | E8 | 20.15 |  |  |  |  | OSE | B3051 | C
A |  | M-A 2012 | AWC | E9 | 24.25 |  |  |  |  | OSE | B3216 | C
A |  | M-A 2012 | AWC | E1 | 11.54 |  |  |  |  | Letter | G3499 | C
A |  | M-A 2012 | AWC | E2 | 10 |  |  |  |  | Letter | G3504 | C
A |  | M-A 2012 | AWC | E3 | 10 |  |  |  |  | Letter | G3505 | C
A |  | M-A 2012 | AWC | E5 | 11.54 |  |  |  |  | Letter | G3500 | C
A |  | M-A 2012 | AWC | E6 | 11.54 |  |  |  |  | Letter | G3501 | C
A |  | M-A 2012 | AWC | E7 | 23.48 |  |  |  |  | Letter | G3502 | C
A |  | M-A 2012 | AWC | E8 | 10 |  |  |  |  | Letter | [NAME] | C
A |  | M-A 2012 | AWC | E9 | 23.48 |  |  |  |  | Letter | G3502 | C
A |  | M-A 2012 | AWC | E1 | 46 |  |  |  |  | Form | F3870 | C | 108744
A |  | M-A 2012 | AWC | E1.5 | 7.6 |  |  |  |  | Form | F3877 | C | 0
A |  | M-A 2012 | AWC | E2 | 7.6 |  |  |  |  | Form | F3800 | C | 0
A |  | M-A 2012 | AWC | E3 | 123.12 |  |  |  |  | Form | F3869 | C
A |  | M-A 2012 | AWC | E4 | 14.74 |  |  |  |  | Form | F3879 | C
A |  | M-A 2012 | AWC | E5 | 9.24 |  |  |  |  | Form | F3880 | C
A |  | M-A 2012 | AWC | E6 | 27.21 |  |  |  |  | Form | F3881 | C
A |  | M-A 2012 | AWC | E7 | 95.32 |  |  |  |  | Form | F3792 | C
A |  | M-A 2012 | AWC | E8 | 8.87 |  |  |  |  | Form | F3882 | C
A |  | M-A 2012 | AWC | E9 | 95.32 |  |  |  |  | Form | F3792 | C
A |  | M-A 2012 | AWC | E1 | 7.38 |  |  |  |  | [NAME] | A3332 | C
A |  | M-A 2012 | AWC | E1 | 7.38 |  |  |  |  | [NAME] | [NAME] | C
A |  | M-A 2012 | AWC | E3 | 7.38 |  |  |  |  | [NAME] | A3333 | C
A |  | M-A 2012 | AWC | E4 | 7.38 |  |  |  |  | [NAME] | A3260 | C
A |  | M-A 2012 | AWC | E5 | 7.38 |  |  |  |  | [NAME] | A3334 | C
A |  | M-A 2012 | AWC | E8 | 7.38 |  |  |  |  | [NAME] | A3335 | C
A |  | M-A 2012 | AWC | E9 | 7.38 |  |  |  |  | [NAME] | A3336 | C
A |  | M-A 2012 | AWC | E1 | 10.93 |  |  |  |  | RE | C2923 | C
A |  | M-A 2012 | AWC | E1.5 | 9.97 |  |  |  |  | RE | C2924 | C
A |  | M-A 2012 | AWC | E2 | 9.97 |  |  |  |  | RE | C2924 | C
A |  | M-A 2012 | AWC | E3 | 11.56 |  |  |  |  | RE | C2925 | C
A |  | M-A 2012 | AWC | E4 | 9.97 |  |  |  |  | RE | C2924 | C
A |  | M-A 2012 | AWC | E5 | 10.93 |  |  |  |  | RE | C2923 | C
A |  | M-A 2012 | AWC | E6 | 10.93 |  |  |  |  | RE | C2923 | C
A |  | M-A 2012 | AWC | E7 | 11.56 |  |  |  |  | RE | C2925 | C
A |  | M-A 2012 | AWC | E8 | 13.69 |  |  |  |  | RE | C2926 | C
A |  | M-A 2012 | AWC | E9 | 11.56 |  |  |  |  | RE | C2925 | C
A |  | M-A 2012 | AWC | E6 | 30.51 |  |  |  |  | Decal | Decal | C
 |  | S-F 2013 | AWC DEC | E1 | 0 |  |  |  |  | OSE | B3353 | T
 |  | S-F 2013 | AWC FEB | E1 | 0 |  |  |  |  | OSE | B3356 | T
 |  | S-F 2013 | AWC DEC | E1.5 | 0 |  |  |  |  | OSE | B3357 | T
 |  | S-F 2013 | AWC DEC | E2 | 0 |  |  |  |  | OSE | B3358 | T
 |  | S-F 2013 | AWC DEC | E2 | 0 |  |  |  |  | Letter | G3617 | T
 |  | S-F 2013 | AWC DEC | E1 | 0 |  |  |  |  | Form | F4021 | T
 |  | S-F 2013 | AWC FEB | E1 | 0 |  |  |  |  | Form | F4024 | T
 |  | S-F 2013 | AWC DEC | E1.5 | 0 |  |  |  |  | Form | F4022 | T
 |  | S-F 2013 | AWC DEC | E2 | 0 |  |  |  |  | Form | F4023 | T
 |  | S-F 2013 | AWC FEB | E1 | 0 |  |  |  |  | RE | C3047 | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21226 |  | 2222 |  | 21325 |  | 2179 |  |  | 20676 |  | 6855 |  | 20684 |  | 36 |  |  | 41544 |  | 4585 |  | 2480 |  | 146 |  |  | 14650 |  | 1489 |  | 14332 |  | 1469 |  |  | 12808 |  | 1438 |  | 1196 |  | 12425 |  | 137 |  |  | 11358 |  | 1068 |  | 11299 |  | 936 |  |  | 10244 |  | 1024 |  | 10020 |  | 927 |  |  | 44948 |  | 3360 |  | 369 |  | 112 |  |  | 21827 |  | 564 |  | 16315 |  |  | 10300 |  | 9770 |  | 598
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 598