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

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
DS10DFL | HIT-AMB-DS10DFL |  | 89 | 110 | 80 |  |  |  | X
 | HIT-DRL-DS10DFL | 1 |  | 35 | 36 |  |  |  | X
 | HIT-CHG-UC10SFL | 1 |  | 35 | 40 |  |  |  | X
 | HIT-BAT-BCL1015 | 2 |  | 75 | 79 |  |  |  | X
 | - | 1 |  | 0 | 0
DS12DVF3 | HIT-AMB-DS12DVF3 |  | 66 | 75 | 80 |  |  |  | X
 | HIT-BAT-EB1214S | 2 |  | 80 | 85 |  |  |  | X
 | HIT-CHG-UC18YG | 1 |  | 30 | 36 |  |  |  | X
 | HIT-DRL-DS12DVF3 | 1 |  | 25 | 24 |  |  |  | X
 | HIT-FLS-UB12D | 1 |  | 14 | 17 |  |  |  | X
 | - | 1 |  | 0 | 0
DS18DVF3 | HIT-AMB-DS18DVF3 |  | 72 | 75 | 80 |  |  |  | X
 | HIT-DRL-DS18DVF3 | 1 |  | 35 | 22 |  |  |  | X
 | HIT-CHG-UC18YG | 1 |  | 30 | 36 |  |  |  | X
 | HIT-BAT-EB1814SL | 1 |  | 85 | 87 |  |  |  | X
 | HIT-FLS-UB18D | 1 |  | 13 | 15 |  |  |  | X
 | - | 1 |  | 0 | 0
DS14DFV3-K | HIT-AMB-DS14DFV3_K |  | 79 | 85 | 85 |  |  |  | X
 | HIT-DRL-DS14DVF3 | 1 |  | 35 | 35 |  |  |  | X
 | HIT-FLS-UB18D | 1 |  | 13 | 15 |  |  |  | X
 | HIT-BAT-EB1414S | 2 |  | 84 | 96 |  |  |  | X
 | HIT-CHG-UC18YG | 1 |  | 30 | 36 |  |  |  | X
 | Case | 1 |  | 0 | 0
DS14DSFL-K | HIT-AMB-DS14DSFL_K |  | 83 | 88 | 78 |  |  |  | X
 | HIT-DRL-DS14DSFL | 1 |  | 55 | 57 |  |  |  | X
 | HIT-FLS-UB18DAL | 1 |  | 18 | 20 |  |  |  | X
 | HIT-BAT-BSL1415 | 2 |  | 70 | 105 |  |  |  | X
 | HIT-CHG-UC18YGSL | 1 |  | 30 | 33 |  |  |  | X
 | Case | 1 |  | 0 | 0
[NAME] | HIT-AMB-DB3DL2_K |  | 40 | 83 | 85 |  |  |  | X
 | HIT-SCD-DB3DL2 | 1 |  | 53 | 56 |  |  |  | X
 | HIT-BAT-EBM315 | 2 |  | 50 | 50 |  |  |  | X
 | HIT-CHG-UC3SFL | 1 |  | 32 | 32 |  |  |  | X
 | Case | 1 |  | 0 | 0
DS18DVF3-K | HIT-AMB-DS18DVF3 |  | 72 | 75 | 80 |  |  |  | X
 | HIT-DRL-DS18DVF3 | 1 |  | 35 | 37 |  |  |  | X
 | HIT-FLS-UB18D | 1 |  | 13 | 15 |  |  |  | X
 | HIT-BAT-EB1814SL | 2 |  | 85 | 87 |  |  |  | X
 | HIT-CHG-UC18YG | 1 |  | 30 | 36 |  |  |  | X
 | Case | 1 |  | 0 | 0
WH10DFL-K | HIT-AMB-WH10DFL_K |  | 90 | 143 | 150 |  |  |  | X
 | HIT-IMP-WH10DFL | 1 |  | 47 | 59 |  |  |  | X
 | HIT-BAT-BCL1015 | 2 |  | 75 | 79 |  |  |  | X
 | HIT-CHG-UC10SFL | 1 |  | 35 | 40 |  |  |  | X
 | Case | 1 |  | 0 | 0
DS18DVC-K | HIT-AMB-DS18DVC_K |  | 69 | 95 | 75 |  |  |  | X
 | HIT-DRL-DS18DVC | 1 |  | 46 | 55 |  |  |  | X
 | HIT-BAT-BCC1812 | 2 |  | 100 | 100 |  |  |  | X
 | HIT-CHG-UC18YG | 1 |  | 30 | 36 |  |  |  | X
 | Case | 1 |  | 0 | 0
WH18DBDL-K | HIT-AMB-WH18DBDL_K |  | 117 | 220 | 265 |  |  |  | X
 | HIT-IMP-WH18DBDL | 1 |  | 75 | 75 |  |  |  | X
 | HIT-BAT-BSL1830 | 2 |  | 120 | 140 |  |  |  | X
 | HIT-CHG-UC18YRSL | 1 |  | 40 | 35 |  |  |  | X
 | Case | 1 |  | 0 | 0
GP10DL-K | HIT-AMB-GP10DL_K |  | 85 | 90 | 83 |  |  |  | X
 | HIT-GRD-GP10DL | 1 |  | 70 | 70 |  |  |  | X
 | HIT-BAT-BCL1015 | 2 |  | 75 | 79 |  |  |  | X
 | HIT-CHG-UC10SFL | 1 |  | 35 | 40 |  |  |  | X
 | - | 1 |  | 0 | 0
DV18DBL | HIT-AMB-DV18DBL |  | 161 | 284 | 296 |  |  |  | X
 | HIT-BAT-BSL1830 | 2 |  | 120 | 140 |  |  |  | X
 | HIT-HMR-DV18DBL | 1 |  | 113 | 121 |  |  |  | X
 | HIT-CHG-UC18YRSL | 1 |  | 40 | 35 |  |  |  | X
 | - | 1 |  | 0 | 0
KC18DHL | HIT-AMB-KC18DHL |  | 161 | 200 | 174 |  |  |  | X
 | HIT-IMP-WH18DSAL | 1 |  | 65 | 83 |  |  |  | X
 | HIT-DRL-DS18DSAL | 1 |  | 65 | 66 |  |  |  | X
 | HIT-CHG-UC18YGSL | 1 |  | 30 | 33 |  |  |  | X
 | HIT-FLS-UB18DAL | 1 |  | 18 | 20 |  |  |  | X
 | HIT-BAT-BSL1815X | 2 |  | 95 | 120 |  |  |  | X
 | - | 1 |  | 0 | 0
KC18DBL | HIT-AMB-KC18DBL |  | 289 | 425 | 625
 | HIT-HDR-DV18DL | 1 |  | 180 | 180
 | HIT-LTN-UB18DL | 1 |  | 29 | 13
 | HIT-CRS-C18DL | 1 |  | 92 | 85
 | HIT-RCS-CR18DL | 1 |  | 85 | 150
 | HIT-CHG-UC18YRL | 1 |  | 25 | 55
 | HIT-BAT-EBM1830 | 2 |  | 150 | 150
 | [NAME] | 1 |  | 0 | 0
DS14DSL | HIT-AMB-DS14DSL |  | 69 | 87 | 90
 | HIT-DRL-DS14DSL | 1 |  | 55 | 55
 | HIT-CHG-UC18YRSL | 1 |  | 30 | 37
 | HIT-BAT-BSL1430 | 2 |  | 220 | 260
 | - | 1 |  | 0 | 0
KC10DFL | HIT-AMB-KC10DFL |  | 126 | 85 | 117
 | HIT-DRL-DS10DFL | 1 |  | 35 | 36
 | HIT-CHG-UC10SFL | 1 |  | 35 | 40
 | HIT-BAT-BCL1015 | 2 |  | 75 | 79
 | HIT-FLS-UB10DL | 1 |  | 17 | 20
 | HIT-BAG-KC10DFL | 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