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

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
P882 | RYB-AMB-P882 |  | 95 | 120 | 110 |  |  |  | X
 | RYB-DRL-P271 | 1 |  | 25 | 35 |  |  |  | X
 | RYB-IMP-P234G | 1 |  | 50 | 40 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
 | RYB-BAT-P102 | 1 |  | 60 | 80 |  |  |  | X
 | RYB-TOT-P882 | 1 |  | 0 | 0
P2102 | RYB-AMB-P2102 |  | 81 | 91 | 120 |  |  |  | X
 | RYB-BLO-P2102 | 1 |  | 50 | 90 |  |  |  | X
 | RYB-BAT-P102 | 1 |  | 60 | 80 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
P818 | RYB-AMB-P818 |  | 90 | 85 | 91 |  |  |  | X
 | RYB-DRL-P208B | 1 |  | 39 | 38 |  |  |  | X
 | RYB-CHG-P117 | 1 |  | 35 | 35 |  |  |  | X
 | RYB-BAT-P107 | 2 |  | 80 | 130 |  |  |  | X
 | RYB-TOT-P818 | 1 |  | 0 | 0
P2060 | RYB-AMB-P2060 |  | 79 | 130 | 150 |  |  |  | X
 | RYB-SGT-P2006 | 1 |  | 22 | 80 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
 | RYB-BAT-P105 | 1 |  | 38 | 85 |  |  |  | X
P2210 | RYB-AMB-P2210 |  | 90 | 120 | 120 |  |  |  | X
 | RYB-SGT-P2210 | 1 |  | 70 | 80 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
 | RYB-BAT-P102 | 1 |  | 30 | 40 |  |  |  | X
HJP002K | RYB-AMB-HJP002K |  | 63 | 85 | 108 |  |  |  | X
 | RYB-BAT-CB120L | 2 |  | 80 | 80 |  |  |  | X
 | RYB-CHG-C120D | 1 |  | 38 | 42 |  |  |  | X
 | RYB-DRL-HJP002 | 1 |  | 25 | 21 |  |  |  | X
 | RYB-CAS-HJP002K | 1 |  | 0 | 0
P824 | RYB-AMB-P824 |  | 129 | 75 | 130 |  |  |  | X
 | RYB-DRL-P206 | 1 |  | 30 | 40 |  |  |  | X
 | RYB-CRS-P501_BL | 1 |  | 25 | 40 |  |  |  | X
 | RYB-CHG-P115 | 1 |  | 23 | 25 |  |  |  | X
 | RYB-BAT-P100 | 2 |  | 83 | 75 |  |  |  | X
 |  | 1 |  | 0 | 0
P2603 | RYB-AMB-P2603 |  | 95 | 95 | 130 |  |  |  | X
 | RYB-HGT-P2603 | 1 |  | 55 | 55 |  |  |  | X
 | RYB-BAT-P102 | 2 |  | 60 | 80 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
P128 | RYB-AMB-P128 |  | 50 | 87 | 90 |  |  |  | X
 | RYB-CHG-P117 | 1 |  | 35 | 35 |  |  |  | X
 | RYB-BAT-P102 | 1 |  | 60 | 80 |  |  |  | X
P852 | RYB-AMB-P852 |  | 63 | 69 | 65 |  |  |  | X
 | RYB-DRL-P270 | 1 |  | 35 | 23 |  |  |  | X
 | RYB-BAT-P100 | 1 |  | 41.5 | 37.5 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
P850 | RYB-AMB-P850 |  | 63 | 68 | 120 |  |  |  | X
 | RYB-DRL-P204 | 1 |  | 28 | 50 |  |  |  | X
 | RYB-BAT-P100 | 2 |  | 83 | 75 |  |  |  | X
 | RYB-CHG-P115 | 1 |  | 23 | 25 |  |  |  | X
 |  | 1 |  | 0 | 0
P2040 | RYB-AMB-P2040 |  | 39 | 70 | 70 |  |  |  | X
 | RYB-SGT-P2004 | 1 |  | 32 | 32 |  |  |  | X
 | RYB-BAT-P100 | 1 |  | 41.5 | 37.5 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
RY24210A | RYB-AMB-RY24210A |  | 99 | 110 | 115 |  |  |  | X
 | RYB-SGT-RY24001 | 1 |  | 35 | 35 |  |  |  | X
 | RYB-CHG-OP140 | 1 |  | 40 | 43 |  |  |  | X
 | RYB-BAT-OP242 | 1 |  | 54 | 96 |  |  |  | X
RY24310 | RYB-AMB-RY24310 |  | 99 | 122 | 115 |  |  |  | X
 | RYB-EDG-RY24001 | 1 |  | 40 | 40 |  |  |  | X
 | RYB-CHG-OP140 | 1 |  | 40 | 43 |  |  |  | X
 | RYB-BAT-OP243 | 1 |  | 65 | 80 |  |  |  | X
P543 | RYB-AMB-P543 |  | 99 | 165 | 164 |  |  |  | X
 | RYB-CHS-P542 | 1 |  | 25 | 95 |  |  |  | X
 | RYB-BAT-P102 | 1 |  | 30 | 40 |  |  |  | X
 | RYB-CHG-P118 | 1 |  | 23 | 23 |  |  |  | X
P883 | RYB-AMB-P883 |  | 144 | 145 | 260
 | RYB-DRL-P271 | 1 |  | 25 | 35
 | RYB-RCS-P515 | 1 |  | 38 | 56
 | RYB-CRS-P504G | 1 |  | 41 | 50
 | RYB-FLS-P701G | 1 |  | 22 | 22
 | RYB-CHG-P118 | 1 |  | 23 | 23
 | RYB-BAT-P102 | 1 |  | 60 | 80
 |  | 1 |  | 0 | 0
P817 | RYB-AMB-P817 |  | 99 | 130 | 130
 | RYB-DRL-P271 | 1 |  | 25 | 35
 | RYB-CHG-P118 | 1 |  | 23 | 23
 | RYB-BAT-P102 | 2 |  | 60 | 80
 | Toolbag | 1 |  | 0 | 0
P884 | RYB-AMB-P884 |  | 270 | 240 | 280
 | RYB-DRL-P208B | 1 |  | 39 | 38
 | RYB-IMP-P236 | 1 |  | 68 | 93
 | RYB-FLS-P704 | 1 |  | 18 | 19
 | RYB-MLT-P246 | 1 |  | 60 | 100
 | RYB-MLT-P570 | 1 |  | 0 | 0 | 0 |  |  |  | Part of P246
 | RYB-RCS-P514 | 1 |  | 48 | 36
 | RYB-CHG-P117 | 1 |  | 35 | 35
 | RYB-BAT-P107 | 2 |  | 90 | 130
 | RYB-CRS-P506 | 1 |  | 70 | 46
 |  | 1 |  | 0 | 0
P828 | RYB-AMB-P828 |  | 65 | 80 | 80
 | RYB-DRL-P205G | 1 |  | 25 | 25
 | RYB-BAT-P102 | 1 |  | 30 | 40
 | RYB-CHG-P119 | 1 |  | 20 | 20
 | - | 1 |  | 0 | 0
RYB-AMB-P827 | RYB-AMB-P827 |  | 95 | 100 | 180
 | RYB-DRL-P205G | 1 |  | 25 | 25
 | RYB-RCS-P515 | 1 |  | 38 | 56
 | RYB-CHG-P118 | 1 |  | 23 | 23
 | RYB-BAT-P102 | 1 |  | 30 | 40
 | - | 1 |  | 0 | 0
P826 | RYB-AMB-P826 |  | 75.05 | 95 | 133
 | RYB-CHG-P118 | 1 |  | 0 | 0
 | RYB-CHG-P119 | 1 |  | 0 | 0
 | RYB-CHG-P120 | 1 |  | 0 | 0
 | RYB-CHG-P121 | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0