Spreadsheet: 38896d1237074856-compare-data-on-2-separate-worksheets-and-pull-a-reference-cell-test-book
Sheet: MASTER 3

 | SYSTEM | UNIT | MOD | SET | MME | CARD | MSN | CUT | INVOICE | INVOICE LINK | DATE PRO | Location | FINAL | COUNT | DATE | CURRENT LOC | INVENTORY
86 | 73 |  |  |  | 86 | 86 | 70 | 70 | 28 | 0
1 | 10079.1204 | 20.0.1.79 | CTX1147C | 530DWM | 300003000725630 | 89881 69312 00190 5169 | 881676336055 | 336055 | UEMR8SUC |  | GORDON LIST | Shipped 6/28/05 | * | 1
2 | 10006.1204 | 20.0.1.6 | CTX1147C | 530DY2 | 300003000723630 | 89881 69312 00190 5110 | 881676336085 | 336085 | UEMR8SV8 |  | GORDON LIST | Shipped 6/28/05 | ? | 1
3 | 10026.1204 | 20.0.1.26 | CTX1147C | 530DXF | 300003000724630 | 89881 69312 00190 5086 | 881676336082 | 336082 | UEMR8SV5 |  | GORDON LIST | Shipped 6/28/05 | ? | 2
4 | 10062.1204 | 20.0.1.62 | CTX1147C | 520J58 | 300003000239070 | 89881 69312 00190 5250 | 881676336065 | 336065 | UEMR8SUN |  | GORDON LIST | Shipped 6/28/05 | ? | 3
5 | 10063.1204 | 20.0.1.63 | CTX1147C | 520J39 | 300003000226480 | 89881 69312 00190 5474 | 881676336079 | 336079 | UEMR8SV2 |  | GORDON LIST | Shipped 6/28/05 | ? | 4
6 | 10065.1204 | 20.0.1.65 | CTX1147C | 530KHK | 300003000723730 | 89881 69312 00190 5268 | 881676336066 | 336066 | UEMR8SUP |  | GORDON LIST | Shipped 6/28/05 | ? | 5
7 | 10066.1204 | 20.0.1.66 | CTX1147C | 520J71 | 300003000330160 | 89881 69312 00190 5078 | 881676336081 | 336081 | UEMR8SV4 |  | GORDON LIST | Shipped 6/28/05 | ? | 6
8 | 10068.1204 | 20.0.1.68 | CTX1147C | 530K6X | 300003000729700 | 89881 69312 00190 5359 | 881676336075 | 336075 | UEMR8SUY |  | GORDON LIST | Shipped 6/28/05 | ? | 7
9 | 10074.1204 | 20.0.1.74 | CTX1147C | 530KDJ | 300003000727700 | 89881 69312 00190 5284 | 881676336068 | 336068 | UEMR8SUS |  | GORDON LIST | Shipped 6/28/05 | ? | 8
10 | 10075.1204 | 20.0.1.75 | CTX1147C | 530KH8 | 300003000724730 | 89881 69312 00190 5227 |  | NO BILL?? | NO BILL?? |  | GORDON LIST | Shipped 6/28/05 | ? | 9
11 | 10076.1204 | 20.0.1.76 | CTX1147C | 530DYZ | 300003000726630 | 89881 69312 00190 5177 | 881676336056 | 336056 | UEMR8SUD |  | GORDON LIST | Shipped 6/28/05 | ? | 10
12 | 10077.1204 | 20.0.1.77 | CTX1147C | 530KD5 | 300003000728680 | 89881 69312 00190 5334 | 881676336073 | 336073 | UEMR8SUW |  | GORDON LIST | Shipped 6/28/05 | ? | 11
13 | 10078.1204 | 20.0.1.78 | CTX1147C | 530DSK | 300003000721630 | 89881 69312 00190 5201 | 881676336059 | 336059 | [NAME] |  | GORDON LIST | Shipped 6/28/05 | ? | 12
14 | 10082.1204 | 20.0.1.82 | CTX1147C | 530KDC | 300003000732350 | 89881 69312 00190 5292 | 881676336069 | 336069 | UEMR8SUR |  | GORDON LIST | Shipped 6/28/05 | ? | 13
15 | 10084.1204 | 20.0.1.84 | CTX1147C | 530FGS | 300003000730380 | 89881 69312 00190 5318 | 881676336071 | 336071 | UEMR8SUU |  | GORDON LIST | Shipped 6/28/05 | ? | 14
16 | 10092.1204 | 20.0.1.92 | CTX1147C | 520MTV | 300003000322550 | 89881 69312 00190 5151 | 881676336062 | 336062 | UEMR8SUK |  | GORDON LIST | Shipped 6/28/05 | ? | 15
17 | 10094.1204 | 20.0.1.94 | CTX1147C | 520MLO | 300003000334180 | 89881 69312 00190 5326 | 881676336072 | 336072 | UEMR8SUV |  | GORDON LIST | Shipped 6/28/05 | ? | 16
18 | 10095.1204 | 20.0.1.95 | CTX1147C | 520MR9 | 300003000337160 | 89881 69312 00190 5243 | 881676336064 | 336064 | UEMR8SUM |  | GORDON LIST | Shipped 6/28/05 | ? | 17
19 | 10004.1204 | 20.0.1.4 | CTX1147C | 530K9K | 300003000734370 | 89881 69312 00190 5375 | 881676336077 | 336077 | UEMR8SV1 |  | GORDON LIST | Shipped 6/28/05 | X | 1
20 | 10009.1204 | 20.0.1.9 | CTX1147C | 530DWV | 300003000732300 | 89881 69312 00190 5102 | 881676336084 | 336084 | UEMR8SV7 |  | GORDON LIST | Shipped 6/28/05 | X | 2
21 | 10010.1204 | 20.0.1.10 | CTX1147C | 530CCC | 300003000739040 | 89881 69312 00189 2292 | 881676310571 | 310571 | NO BILL?? |  |  | Shipped 3/23/05 | X | 3
22 | 10032.1204 | 20.0.1.32 | CTX1147C | 530B7Y | 300003000720110 | 89881 69312 00189 2789 | 881676310598 | 310598 | NO BILL?? |  |  | [NAME] | X | 7
23 | 10039.1204 | 20.0.1.39 | CTX1147C | 530B02 | 300003000637760 | 89881 69312 00189 2177 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | X | 11
24 | 10047.1204 | 20.0.1.47 | CTX1147C | 520MKM | 300003000320550 | 89881 69312 00189 2169 | 881676310527 | 310527 | NO BILL?? |  |  | Shipped 3/23/05 | X | 12
25 | 10048.1204 | 20.0.1.48 | CTX1147C | 520GD6 | 300003000323520 | 89881 69312 00189 2425 | 881676310286 | 310286 | NO BILL?? |  |  | Shipped 3/23/05 | X | 13
26 | 10051.1204 | 20.0.1.51 | CTX1147C | 530KGW | 300003000725730 | 89881 69312 00190 5367 | 881676336076 | 336076 | UEMR8SUZ |  | GORDON LIST | Shipped 6/28/05 | X | 14
27 | 10059.1204 | 20.0.1.59 | CTX1147C | 520MP2 | 300003000331160 | 89881 69312 00189 2508 | 881676310520 | 310520 | UEMR8ULS |  | GORDON LIST | Shipped 3/23/05 | X | 16
28 | 10060.1204 | 20.0.1.60 | CTX1147C | 530KBP | 300003000724680 | 89881 69312 00190 5128 | 881676336086 | 336086 | UEMR8SV9 |  | GORDON LIST | Shipped 6/28/05 | X | 17
29 | 10061.1204 | 20.0.1.61 | CTX1147C | 520MLM | 300003000330190 | 89881 69312 00190 5466 | 881676336078 | 336078 | UEMR8SV0 |  | GORDON LIST | Shipped 6/28/05 | X | 18
30 | 10064.1204 | 20.0.1.64 | CTX1147C | 530KJN | 300003000725680 | 89881 69312 00189 6012 |  | NO BILL?? | ?? |  |  | Production | X | 19
31 | 10080.1204 | 20.0.1.80 | CTX1147C | 530F3J | 300003000735300 | 89881 69312 00190 5193 | 881676336058 | 336058 | UEMR8SUG |  | GORDON LIST | Shipped 6/28/05 | X | 21
32 | 10081.1204 | 20.0.1.81 | CTX1147C | 530KD8 | 300003000734350 | 89881 69312 00190 5219 | 881676336060 | 336060 | UEMR8SUH |  | GORDON LIST | [NAME] 5/20/05 | X | 22
33 | 10098.1204 | 20.0.1.98 | CTX1147C | 520MVF | 300003000338160 | 89881 69312 00190 5185 | 881676336057 | 336057 | UEMR8SUE |  | GORDON LIST | Shipped 6/28/05 | X | 23
34 | 10001.1204 | 20.0.1.1 | CTX1147C | 520MWD | 300003000326520 | 89881 69312 00189 2664 | 881676310600 | 310600 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 1
35 | 10002.1204 | 20.0.1.2 | CTX1147C | 530B52 | 300003000723060 | 89881 69312 00189 2672 | 881676310601 | 310601 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 2
36 | 10003.1204 | 20.0.1.3 | CTX1147C | 520MVM | 300003000320530 | 89881 69312 00189 2680 | 881676310602 | 310602 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 3
37 | 10005.1204 | 20.0.1.5 | CTX1147C | 520MKV | 300003000331190 | 89881 69312 00189 2706 | 881676310606 | 310606 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 4
38 | 10007.1204 | 20.0.1.7 | CTX1147C | 520J7R | 300003000334150 | 89881 69312 00189 2722 | 881676310613 | 310613 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 5
39 | 10008.1204 | 20.0.1.8 | CTX1147C | 520MMT | 300003000339150 | 89881 69312 00189 2730 | 881676310614 | 310614 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 6
40 | 10011.1204 | 20.0.1.11 | CTX1147C | 530CCS | 300003000721370 | 89881 69312 00189 2235 | 881676310550 | 310550 | NO BILL?? |  | REQUEST DENIED | Shipped 3/23/05 | Z | 7
41 | 10012.1204 | 20.0.1.12 | CTX1147C | 530B2P | 300003000728070 | 89881 69312 00189 2227 | 881676310546 | 310546 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 8
42 | 10013.1204 | 20.0.1.13 | CTX1147C | 520MV5 | 300003000327510 | 89881 69312 00189 2219 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | Z | 9
43 | 10014.1204 | 20.0.1.14 | CTX1147C | 520MR8 | 300003000332150 | 89881 69312 00189 2201 | 881676310540 | 310540 | NO BILL?? |  | REQUEST DENIED | Shipped 3/23/05 | Z | 10
44 | 10015.1204 | 20.0.1.15 | CTX1147C | 520MMJ | 300003000332170 | 89881 69312 00189 2391 | 881676310254 | 310254 | NO BILL?? |  | REQUEST DENIED | [NAME] | Z | 11
45 | 10016.1204 | 20.0.1.16 | CTX1147C | 520MN8 | 300003000332160 | 89881 69312 00189 2805 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | Z | 12
46 | 10017.1204 | 20.0.1.17 | CTX1147C | 520MRG | 300003000325510 | 89881 69312 00189 2284 | 881676310569 | 310569 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 13
47 | 10018.1204 | 20.0.1.18 | CTX1147C | 520MTH | 300003000321520 | 89881 69312 00190 5060 | 881676336080 | 336080 | UEMR8SV3 |  |  | Shipped 6/28/05 | Z | 14
48 | 10019.1204 | 20.0.1.19 | CTX1147C | 530B15 | 300003000722080 | 89881 69312 00189 2573 |  | NO BILL?? | ?? |  |  | [NAME] | Z | 15
49 | 10021.1204 | 20.0.1.21 | CTX1147C | 520MNW | 300003000338150 | 89881 69312 00189 2581 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | Z | 16
50 | 10022.1204 | 20.0.1.22 | CTX1147C | 53092B | 300003000636790 | 89881 69312 00189 2607 | 881676310136 | 310136 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 17
51 | 10024.1204 | 20.0.1.24 | CTX1147C | 520J20 | 300003000238070 | 89881 69312 00189 2599 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | Z | 18
52 | 10025.1204 | 20.0.1.25 | CTX1147C | 520MN9 | 300003000339180 | 89881 69312 00189 2623 | 881676310138 | 310138 | NO BILL?? |  |  | [NAME]up 4/5/05 | Z | 19
53 | 10027.1204 | 20.0.1.27 | CTX1147C | 530B6J | 300003000636750 | 89881 69312 00189 2649 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | Z | 20
54 | 10028.1204 | 20.0.1.28 | CTX1147C | 520MMS | 300003000325520 | 89881 69312 00189 2359 |  | NO BILL?? | ?? |  |  | [NAME] | Z | 21
55 | 10029.1204 | 20.0.1.29 | CTX1147C | 520MV2 | 300003000324520 | 89881 69312 00189 2375 |  | NO BILL?? | ?? |  |  | [NAME] | Z | 22
56 | 10031.1204 | 20.0.1.31 | CTX1147C | 520ML1 | 300003000335180 | 89881 69312 00189 2656 | 881676310599 | 310599 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 23
57 | 10033.1204 | 20.0.1.33 | CTX1147C | 530B08 | 300003000635750 | 89881 69312 00189 2771 | 881676310597 | 310597 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 24
58 | 10034.1204 | 20.0.1.34 | CTX1147C | 530B74 | 300003000725060 | 89881 69312 00189 2763 | 881676310596 | 310596 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 25
59 | 10038.1204 | 20.0.1.38 | CTX1147C | 520J4F | 300003000229470 | 89881 69312 00189 2342 |  | NO BILL?? |  |  |  | Shipped 3/23/05 | Z | 26
60 | 10040.1204 | 20.0.1.40 | CTX1147C | 520MMZ | 300003000333150 | 89881 69312 00189 2334 | OEF/RCE  TF/06/07 | NO BILL?? |  |  |  | Shipped 3/23/05 | Z | 27
61 | 10041.1204 | 20.0.1.41 | CTX1147C | 520J4Y | 300003000221480 | 89881 69312 00189 2524 | 881676310522 | 310522 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 28
62 | 10042.1204 | 20.0.1.42 | CTX1147C | 5309X5 | 300003000631780 | 89881 69312 00189 2383 | 881676310053 | 310053 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 29
63 | 10043.1204 | 20.0.1.43 | CTX1147C | 520MS0 | 300003000332190 | 89881 69312 00189 2532 | 881676310524 | 310524 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 30
64 | 10044.1204 | 20.0.1.44 | CTX1147C | 520MKL | 300003000328510 | 89881 69312 00189 2540 | 881676310525 | 310525 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 31
65 | 10045.1204 | 20.0.1.45 | CTX1147C | 520J55 | 300003000232080 | 89881 69312 00189 9751 | 881676310526 | 310526 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 32
66 | 10046.1204 | 20.0.1.46 | CTX1147C | 530CB4 | 300003000729370 | 89881 69312 00189 2516 | 881676310521 | 310521 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 33
67 | 10049.1204 | 20.0.1.49 | CTX1147C | 520MV7 | 300003000326540 | 89881 69312 00189 2417 |  | NO BILL?? | ?? |  |  | Shipped 3/23/05 | Z | 34
68 | 10050.1204 | 20.0.1.50 | CTX1147C | 520MWT | 300003000335150 | 89881 69312 00189 2409 | 881676310263 | 310263 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 35
69 | 10053.1204 | 20.0.1.53 | CTX1147C | 520MLP | 300003000328540 | 89881 69312 00189 2441 | 881676310349 | 310349 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 36
70 | 10054.1204 | 20.0.1.54 | CTX1147C | 520MKH | 300003000322530 | 89881 69312 00189 2458 | OEF/RCE TF DUKE | NO BILL?? | ?? |  |  | Shipped 6/28/05 | Z | 37
71 | 10055.1204 | 20.0.1.55 | CTX1147C | 520MVD | 300003000331170 | 89881 69312 00189 2466 | 881676310363 | 310363 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 38
72 | 10056.1204 | 20.0.1.56 | CTX1147C | 520MSP | 300003000338180 | 89881 69312 00189 2474 | 881676310383 | 310383 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 39
73 | 10057.1204 | 20.0.1.57 | CTX1147C | 520MWS | 300003000323550 | 89881 69312 00189 2482 | 881676310460 | 310460 | NO BILL?? |  |  | Shipped 3/23/05 | Z | 40
74 | 10058.1204 | 20.0.1.58 | CTX1147C | 530B1W | 300003000720080 | 89881 69312 00189 2490 | 881676310511 | 310511 | NO BILL?? |  |  | [NAME] | Z | 41
75 | 10069.1204 | 20.0.1.69 | CTX1147C | 530K68 | 300003000731350 | 89881 69312 00189 2748 | 881676310622 | 310622 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 42
76 | 10071.1204 | 20.0.1.71 | CTX1147C | 530F5P | 300003000739300 | 89881 69312 00189 2698 | 881676310605 | 310605 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 43
77 | 10072.1204 | 20.0.1.72 | CTX1147C | 530B56 | 300003000636780 | 89881 69312 00190 5300 | 881676336070 | 336070 | UEMR8SUT |  |  | Shipped 6/28/05 | Z | 44
78 | 10073.1204 | 20.0.1.73 | CTX1147C | 530DTN | 300003000738050 | 89881 69312 00190 5342 | 881676336074 | 336074 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 45
79 | 10083.1204 | 20.0.1.83 | CTX1147C | 520MTP | 300003000336180 | 89881 69312 00189 2318 | 881676310582 | 310582 | NO BILL?? |  |  | Rich McQ 4/28/05 | Z | 46
80 | 10088.1204 | 20.0.1.88 | CTX1147C | 520MPK | 300003000335160 | 89881 69312 00189 2193 | 881676310539 | 310539 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 47
81 | 10089.1204 | 20.0.1.89 | CTX1147C | 520MNZ | 300003000337150 | 89881 69312 00189 2631 |  | NO BILL?? | ?? |  |  | Shipped 6/28/05 | Z | 48
82 | 10090.1204 | 20.0.1.90 | CTX1147C | 520MWM | 300003000328520 | 89881 69312 00190 5235 | 881676336063 | 336063 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 49
83 | 10093.1204 | 20.0.1.93 | CTX1147C | 520MVV | 300003000327520 | 89881 69312 00190 5276 | 881676336067 | 336067 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 50
84 | 10096.1204 | [NAME] | CTX1147C | 520MPN | 300003000337180 | 89881 69312 00189 2714 | 881676310610 | 310610 | NO BILL?? |  |  | McQ  5/25/05 | Z | 51
85 | 10097.1204 | 20.0.1.97 | CTX1147C | 520MRC | 300003000330170 | 89881 69312 00189 2185 | 881676310538 | 310538 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 52
86 | 10099.1204 | 20.0.1.99 | CTX1147C | 520MNK | 300003000333160 | 89881 69312 00189 2326 | 881676310586 | 310586 | NO BILL?? |  |  | Shipped 6/28/05 | Z | 53