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

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
2691-22 | MIL-AMB-2691_22 |  | 180 | 200 | 237 |  |  |  | X
 | [NAME]-DRL-2601_20 | 1 |  | 55 | 66 |  |  |  | X
 | MIL-IMP-2650_20 | 1 |  | 70 | 124 |  |  |  | X
 | MIL-CHG-48_59_1812 | 1 |  | 23 | 26 |  |  |  | X
 | MIL-BAT-48_11_1815 | 2 |  | 85 | 90 |  |  |  | X
 | MIL-BAG-10INCH | 1 |  | 0 | 0
2590-20P | MIL-AMB-2590_20P |  | 134 | 90 | 150 |  |  |  | X
 | MIL-RAD-2590_20 | 1 |  | 80.5 | 79 |  |  |  | X
 | MIL-DRL-2401_20 | 1 |  | 45 | 37 |  |  |  | X
 | [NAME]-CHG-48_59_2401 | 1 |  | 14 | 23 |  |  |  | X
 | MIL-BAT-48_11_2401 | 1 |  | 55 | 60 |  |  |  | X
 | Case | 1 |  | 0 | 0 |  |  |  | X
2696CT | MIL-AMB-2696CT |  | 162 | 190 | 182 |  |  |  | X
 | [NAME]-DRL-2601_20 | 1 |  | 200 | 237 |  |  |  | X
 | MIL-BAT-48_11_1815 | 2 |  | 85 | 90 |  |  |  | X
 | MIL-CHG-48_59_1812 | 1 |  | 23 | 26 |  |  |  | X
 | MIL-JGS-2625_20 | 1 |  | 68 | 84 |  |  |  | X
 | - | 0 |  | 0 | 0
2407-22 | MIL-AMB-2407_22 |  | 90 | 120 | 215 |  |  |  | X
 | MIL-DRL-2407_20 | 1 |  | 62.5 | 126 |  |  |  | X
 | MIL-BAT-48_11_2401 | 1 |  | 55 | 60 |  |  |  | X
 | [NAME]-CHG-48_59_2401 | 1 |  | 14 | 23 |  |  |  | X
 | MIL-CAS-2407_22 | 1 |  | 0 | 0
2697-22CT | [NAME]-AMB-2697_22CT |  | 180 | 250 | 265 |  |  |  | X
 | MIL-HDR-2602_20 | 1 |  | 62 | 66 |  |  |  | X
 | MIL-IMP-2650_20 | 1 |  | 70 | 124 |  |  |  | X
 | MIL-BAT-48_11_1815 | 2 |  | 85 | 90 |  |  |  | X
 | MIL-CHG-48_59_1801 | 1 |  | 45 | 85 |  |  |  | X
 | Case | 1 |  | 0 | 0
2604-22 | MIL-AMB-2604_22 |  | 119 | 250 | 259 |  |  |  |  | no longer avaliable at reasonable $
 | MIL-HDR-2604_20 | 1 |  | 89 | 110
 | MIL-CHG-48_59_1812 | 1 |  | 20 | 20
 | [NAME] | 2 |  | 116 | 139
 | Case | 1 |  | 0 | 0
2696-24 | MIL-AMB-2696_24 |  | 359 | 354 | 390
 | MIL-HDR-2602_20 | 1 |  | 72 | 60
 | MIL-IMP-2650_20 | 1 |  | 60 | 95
 | MIL-RCS-2620_20 | 1 |  | 85 | 89
 | MIL-FLS-49_24_0171 | 1 |  | 35 | 42
 | MIL-CHG-48_59_1801 | 1 |  | 35 | 64
 | [NAME] | 2 |  | 116 | 139
 | ToolBag | 1 |  | 0 | 0
2445-21 | MIL-AMB-2445_21 |  | 65 | 98 | 104
 | MIL-JGS-2445_20 | 1 |  | 78 | 89
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | MIL-BAT-48_11_2401 | 1 |  | 28 | 33
 | [NAME] | 1 |  | 0 | 0
2457-21 | MIL-AMB-2457_21 |  | 96 | 156 | 155
 | MIL-RTC-2457_20 | 1 |  | 41 | 111
 | MIL-BAT-48_11_2401 | 1 |  | 28 | 33
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | [NAME] | 1 |  | 0 | 0
2101-21 | MIL-AMB-2101_21 |  | 59 | 110 | 301
 | MIL-SCD-2101_20 | 1 |  | 72 | 60
 | [NAME] | 1 |  | 42 | 45
 | MIL-CHG-48_59_2001 | 1 |  | 40 | 40
 | - | 1 |  | 0 | 0
2652-22 | MIL-AMB-2652_22 |  | 236 | 271
 | MIL-IMP-2652_20 | 1 |  | 112 | 112
 | [NAME] | 2 |  | 116 | 139
 | MIL-CHG-48_59_1812 | 1 |  | 20 | 20
 | Case | 1 |  | 0 | 0
2411-22 | MIL-AMB-2411_22 |  | 95 | 145 | 162
 | MIL-HDR-2411_20 | 1 |  | 64 | 85
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | MIL-BAT-48_11_2401 | 2 |  | 28 | 33
 | - | 1 |  | 0 | 0
2450-22 | MIL-AMB-2450_22 |  | 153 | 110 | 159
 | MIL-IMP-2450_20 | 1 |  | 68 | 120
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | MIL-BAT-48_11_2401 | 2 |  | 28 | 33
 | - | 1 |  | 0 | 0
2450-22X | MIL-AMB-2450_22X |  | 153 | 166 | 180
 | MIL-IMP-2450_20 | 1 |  | 68 | 120
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | MIL-BAT-48_11_2401 | 1 |  | 28 | 33
 | [NAME]-BAT-48_11_2402 | 1 |  | 42 | 68
 | - | 1 |  | 0 | 0
2411-22X | MIL-AMB-2411_22X |  | 95 | 170 | 170
 | MIL-HDR-2411_20 | 1 |  | 64 | 85
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | MIL-BAT-48_11_2401 | 1 |  | 28 | 33
 | [NAME]-BAT-48_11_2402 | 1 |  | 42 | 68
 | - | 1 |  | 0 | 0
2602-22 | MIL-AMB-2602_22 |  | 95 | 235 | 260
 | MIL-HDR-2602_20 | 1 |  | 85 | 109
 | MIL-CHG-48_59_1801 | 1 |  | 35 | 64
 | [NAME] | 1 |  | 58 | 64
 | - | 1 |  | 0 | 0
2460-21 | MIL-AMB-2460_21 |  | 95 | 108 | 114
 | MIL-RTT-2460_20 | 1 |  | 80 | 83
 | [NAME]-CHG-48_59_2401 | 1 |  | 13 | 15
 | MIL-BAT-48_11_2401 | 1 |  | 28 | 33
 | - | 1 |  | 0 | 0
2603-22CT | MIL-AMB-2603_22CT |  | 95 | 230 | 264
 | MIL-DRL-2603_20 | 1 |  | 82 | 104
 | MIL-CHG-48_59_1812 | 1 |  | 20 | 20
 | MIL-BAT-48_11_1815 | 2 |  | 85 | 90
 | - | 1 |  | 0 | 0
2696_22CT | MIL-AMB-2696_22CT |  | 200
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0