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

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
DCF680N1 | DEW-AMB-DCF680N1 |  | 72 | 120 | 90 |  |  |  | X
 | DEW-SCD-DCF680 | 1 |  | 45 | 45 |  |  |  | X
 | DEW-CHG-DCB095 | 1 |  | 45 | 48 |  |  |  | X
 | DEW-BAT-DCB080 | 1 |  | 39 | 43 |  |  |  | X
 | DEW-BAG-11MINI | 1 |  | 0 | 0
DCK425C | DEW-AMB-DCK425C |  | 225 | 270 | 270 |  |  |  | X
 | DEW-RCS-DW938 | 1 |  | 78 | 99 |  |  |  | X
 | DEW-IMP-DC825 | 1 |  | 60 | 92 |  |  |  | X
 | DEW-DRL-DC720 | 1 |  | 45 | 55 |  |  |  | X
 | DEW-FLS-DW908 | 1 |  | 25 | 29 |  |  |  | X
 | DEW-BAT-DC9099 | 2 |  | 90 | 92 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | DEW-BAG-18INCH | 1 |  | 23 | 23
DC970K-2 | DEW-AMB-DC970K_2 |  | 85 | 110 | 100 |  |  |  | X
 | DEW-DRL-DC970 | 1 |  | 40 | 43 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | DEW-BAT-DC9098 | 2 |  | 70 | 70 |  |  |  | X
 | DEW-BAG-DC970_2 | 1 |  | 9 | 9
DC759KA | DEW-AMB-DC759KA |  | 89 | 105 | 160 |  |  |  | X
 | DEW-DRL-DC759 | 1 |  | 50 | 45 |  |  |  | X
 | DEW-BAT-DC9098 | 1 |  | 70 | 70 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | DEW-CAS-DC759KA | 1 |  | 0 | 0
DCK313S2R | DEW-AMB-DCK313S2R-RC |  | 146 | 207 | 204 |  |  |  | X
 | DEW-RCS-DCS310-RC | 1 |  | 80 | 77 |  |  |  | X
 | DEW-DRL-DCD710-RC | 1 |  | 55 | 50 |  |  |  | X
 | DEW-IMP-DCF815-RC | 1 |  | 55 | 50 |  |  |  | X
 | DEW-CHG-DCB100-RC | 1 |  | 25 | 40 |  |  |  | X
 | DEW-BAT-DCB120-RC | 2 |  | 50 | 80 |  |  |  | X
 | [NAME] | 1 |  | 16 | 16
DCK297L2 | DEW-AMB-DCK297L2 |  | 269 | 300 | 259 |  |  |  | X
 | DEW-IMP-DCF885 | 1 |  | 70 | 120 |  |  |  | X
 | DEW-RCS-DCS381 | 1 |  | 120 | 100 |  |  |  | X
 | DEW-BAT-DCB200 | 2 |  | 85 | 95 |  |  |  | X
 | DEW-CHG-DCB101 | 1 |  | 30 | 60 |  |  |  | X
 | 1` | 1 |  | 0 | 0
DCF826KL1 | DEW-AMB-DCF826KL1 |  | 119 | 239 | 240 |  |  |  | X
 | DEW-IMP-DCF826 | 1 |  | 48 | 92 |  |  |  | X
 | DEW-BAT-DC9181 | 1 |  | 70 | 99 |  |  |  | X
 | DEW-CHG-DC9310 | 1 |  | 45 | 70 |  |  |  | X
 | Case | 1 |  | 0 | 0
DCK235C | DEW-AMB-DCK235C |  | 126 | 157 | 170 |  |  |  | X
 | DEW-DRL-DC759 | 1 |  | 50 | 45 |  |  |  | X
 | DEW-IMP-DC825 | 1 |  | 60 | 92 |  |  |  | X
 | DEW-BAT-DC9098 | 2 |  | 70 | 70 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | [NAME] | 1 |  | 16 | 16
DW920K_2 | DEW-AMB-DW920K_2 |  | 69 | 90 | 105 |  |  |  | X
 | DEW-SCD-DW920 | 1 |  | 38 | 38 |  |  |  | X
 | DEW-BAT-DW9057 | 2 |  | 65 | 60 |  |  |  | X
 | DEW-CHG-DW9118 | 1 |  | 25 | 43 |  |  |  | X
 | Case | 1 |  | 0 | 0 |  |  |  |  | We sell this case both on eBay and FBA.  Mostly FBA.
[NAME] | DEW-AMB-DW967K |  | 78 | 180 | 168 |  |  |  | X
 | DEW-IMP-DW967 | 1 |  | 70 | 70 |  |  |  | X
 | DEW-BAT-DW9061 | 1 |  | 35 | 40 |  |  |  | X
 | DEW-CHG-DW9107 | 1 |  | 25 | 60 |  |  |  | X
 | Case | 1 |  | 0 | 0
[NAME] | DEW-AMB-DC825K |  | 89 | 130 | 225 |  |  |  | X
 | DEW-IMP-DC825 | 1 |  | 60 | 92 |  |  |  | X
 | DEW-BAT-DC9096 | 1 |  | 50 | 50 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | Case | 1 |  | 0 | 0
DCK236C | DEW-AMB-DCK236C |  | 149 | 110 | 170 |  |  |  | X
 | DEW-DRL-DC759 | 1 |  | 50 | 45 |  |  |  | X
 | DEW-IMP-DC825 | 1 |  | 60 | 92 |  |  |  | X
 | DEW-BAT-DC9099 | 2 |  | 90 | 92 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | Case | 1 |  | 16 | 16
[NAME] | DEW-AMB-DC385K |  | 179 | 170 | 150 |  |  |  | X
 | DEW-RCS-DC385 | 1 |  | 75 | 92 |  |  |  | X
 | DEW-BAT-DC9096 | 1 |  | 100 | 100 |  |  |  | X
 | DEW-CHG-DW9116 | 1 |  | 30 | 44 |  |  |  | X
 | Case | 1 |  | 75 | 80
DC730KA | DEW-AMB-DC730KA |  | 109 | 160 | 193 |  |  |  | X
 | DEW-DRL-DC730 | 1 |  | 70 | 70 |  |  |  | X
 | DEW-BAT-DW9094 | 2 |  | 90 | 110 |  |  |  | X
 | DEW-CHG-DW9118 | 1 |  | 25 | 43 |  |  |  | X
 | Case | 1 |  | 0 | 0
DWLOBAG4 | DEW-AMB-DC940KA |  | 0.99
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0