Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Porterl Cable

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
PCL212IDC_2 | PRC-AMB-PCL212IDC_2 |  | 110 | 130 | 120 |  |  |  | X
 | PRC-DRL-PCL120DD | 1 |  | 43 | 45 |  |  |  | X
 | PRC-IMP-PCL120ID | 1 |  | 47 | 47 |  |  |  | X
 | PRC-CHG-PCL12C | 1 |  | 30 | 35 |  |  |  | X
 | PRC-BAT-PCL12BLX | 2 |  | 49 | 45 |  |  |  | X
 | PRC-TOT-12LI_ION | 1 |  | 0 | 0
PCCK406N2 | PRC-AMB-PCCK406N2 |  | 95 | 140 | 140 |  |  |  | X
 | PRC-DRL-PC1801D | 1 |  | 25 | 25 |  |  |  | X
 | PRC-CRS-PC186CS | 1 |  | 30 | 29 |  |  |  | X
 | PRC- CHG-PCC480N | 1 |  | 25 | 25 |  |  |  | X
 | PRC-BAT-PCC489N | 2 |  | 70 | 70 |  |  |  | X
PCCK413L3 | PRC-AMB-PCCK413L3 |  | 144 | 197 | 190 |  |  |  | X
 | PRC-BAT-PC18BLX | 1 |  | 62 | 66 |  |  |  | X
 | PRC-BAT-PC18BLEX | 1 |  | 72 | 85 |  |  |  | X
 | PRC-CHG-PCXMVC | 1 |  | 32 | 41 |  |  |  | X
 | PRC-DRL-PCL180CD | 1 |  | 34 | 25 |  |  |  | X
 | PRC-IMP-PCL180ID | 1 |  | 46 | 53 |  |  |  | X
 | PRC-RCS-PCL180RS | 1 |  | 35 | 40 |  |  |  | X
 | PRC-BAG-PCCK413L3 | 1 |  | 0 | 0
PCCK605L2 | PRC-AMB-PCCK605L2 |  | 216 | 180 | 170 |  |  |  | X
 | PRC-BAT-PCC680L | 1 |  | 45 | 57 |  |  |  | X
 | PRC-BAT-PCC685L | 1 |  | 70 | 90 |  |  |  | X
 | PRC-CHG-PCC691L | 1 |  | 31 | 30 |  |  |  | X
 | PRC-DRL-PCC601 | 1 |  | 45 | 46 |  |  |  | X
 | PRC-CRS-PCC660 | 1 |  | 56 | 50 |  |  |  | X
 | PRC-BAG-PCCK605L2 | 1 |  | 0 | 0
PC418C-2 | PRC-AMB-PC418C_2 |  | 126 | 160 | 162 |  |  |  | X
 | PRC-BAT-PC18B | 2 |  | 63 | 77 |  |  |  | X
 | PRC-CRS-PC186CS | 1 |  | 30 | 29 |  |  |  | X
 | PRC-DRL-PC1801D | 1 |  | 25 | 25 |  |  |  | X
 | PRC-FLS-PC1800L | 1 |  | 23 | 29 |  |  |  | X
 | PRC-CHG-PCMVC | 1 |  | 26 | 34 |  |  |  | X
 | PRC-RCS-PC1800RS | 1 |  | 35 | 49 |  |  |  | X
 | PRC-CAS-PC418C_2 | 1 |  | 0 | 0
PC180DK-2 | PRC-AMB-PC180DK_2 |  | 72 | 112 | 90 |  |  |  | X
 | PRC-DRL-PC1800D | 1 |  | 25 | 30 |  |  |  | X
 | PRC-BAT-PC18B | 2 |  | 63 | 77 |  |  |  | X
 | PRC-CHG-PCMVC | 1 |  | 26 | 34 |  |  |  | X
 | - | 1 |  | 0 | 0
PCC440LA | PRC-AMB-PCC440LA |  | 72 | 70 | 140 |  |  |  | X
 | PRC-DRL-PCL180D | 1 |  | 28 | 25 |  |  |  | X
 | PRC-BAT-PC18BLX | 1 |  | 130 | 150 |  |  |  | X
 | PRC-CHG-PCXMVC | 1 |  | 32 | 41 |  |  |  | X
 | - | 1 |  | 0 | 0
PCC601LB | PRC-AMB-PCC601LB |  | 117 | 167 | 150 |  |  |  | X
 | PRC-DRL-PCC601 | 1 |  | 46 | 47 |  |  |  | X
 | PRC-BAT-PCC681L | 2 |  | 64 | 94 |  |  |  | X
 | PRC-CHG-PCC690L | 1 |  | 31 | 36 |  |  |  | X
 | BAG | 1 |  | 0 | 0
PCL120MTC-2 | PRC-AMB-PCL120MTC_2 |  | 49 | 78 | 68 |  |  |  | X
 | PRC-MLT-PCL120MT | 1 |  | 50 | 53 |  |  |  | X
 | PRC-BAT-PCL12BLX | 2 |  | 49 | 45 |  |  |  | X
 | PRC-CHG-PCL12C | 1 |  | 30 | 35 |  |  |  | X
 | PRC-ACC-PCL120MTCBOX | 1 |  | 0 | 0 |  |  |  | X
 | BAG14" | 1 |  | 0 | 0
PCCK640LB | PRC-AMB-PCCK640LB |  | 117 | 132 | 140
 | PRC-IMP-PCC640 | 1 |  | 46 | 60
 | PRC-BAT-PCC680L | 2 |  | 78 | 108
 | PRC-CHG-PCC690L | 1 |  | 32 | 37
 | SM Hard case | 1 |  | 0 | 0
PCCK410L2 | PRC-AMB-PCCK410L2 |  | 113 | 158 | 150
 | PRC-DRL-PCL180CD | 1 |  | 24 | 25
 | PRC-IMP-PCL180ID | 1 |  | 42 | 53
 | PRC-CHG-PCXMVC | 1 |  | 28 | 35
 | PRC-BAT-PC18BLX | 2 |  | 92 | 149
 | Toolbag | 1 |  | 0 | 0
PCC642LA | PRC-AMB-PCC642LA |  | 75 | 134 | 140
 | PRC-IMP-PCC640 | 1 |  | 38 | 60
 | PRC-CHG-PCC690L | 1 |  | 32 | 37
 | PRC-BAT-PCC680L | 1 |  | 39 | 54
 | - | 1 |  | 0 | 0
PCCK60L2 | PRC-AMB-PCCK60L2 |  | 162 | 135 | 170
 | PRC-IMP-PCC640 | 1 |  | 38 | 60
 | PRC-DRL-PCC600 | 1 |  | 38 | 48
 | PRC-CHG-PCC690L | 1 |  | 32 | 37
 | PRC-BAT-PCC680L | 2 |  | 39 | 54
 | Toolbag | 1 |  | 0 | 0
PCCK405N4 | PRC-AMB-PCCK405N4 |  | 95 | 130 | 140
 | PRC-DRL-PC1801D | 1 |  | 25 | 25
 | PRC-RCS-PC1800RS | 1 |  | 35 | 49
 | PRC-CRS-PC186CS | 1 |  | 30 | 29
 | PRC-CHG-PCC480N | 1 |  | 25 | 25
 | PRC-FLS-PC1800L | 1 |  | 23 | 29
 | PRC-BAT-PCC489N | 2 |  | 70 | 70
 | - | 1 |  | 0 | 0
PCCK614L4 | PRC-AMB-PCCK614L4 |  | 215 | 237
 | PRC-CRS-PCC660 | 1 |  | 56 | 50
 | PRC-CHG-PCC691L | 1 |  | 31 | 30
 | PRC-BAT-PCC680L | 1 |  | 78 | 108
 | PRC-BAT-PCC685L | 1 |  | 70 | 90
 | PRC-RCS-PCC670 | 1 |  | 59 | 59
 | PRC-DRL-PCC601 | 1 |  | 64 | 60
 | PRC-FLS-PCC700 | 1 |  | 39 | 25
 | PRC-BAG-PCCK614L4 | 1 |  | 0 | 0
PCC842L | PRC-AMB-PCC842L |  | 45 | 70 | 72
 | PRC-DRL-PCC842L | 1 |  | 0 | 0
 | PRC-CHG-90598680 | 1 |  | 0 | 0
 | - | 1 |  | 0 | 0
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0