Spreadsheet: 802332d1666791362-nested-vlookup-and-ifs-test-for-excel-forum
Sheet: Data

Product List | Classification | Minimum target price per change, per piece | Current average price per change, per piece | Variance to Minimum Target Price (Profitable) |  |  | Variance to Minimum Target Price (Non Profitable)
 |  |  |  | -1% to -10% | -10% to -49% | -49% + | 0% to 10% | 10.1% to 15% | 15.1% to 22% | 22.1% +
Absorbent [NAME] | [NAME] | 1 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Absorbent Mat Container | [NAME] | 2.27 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Absorbent Mat DE 200x60 | Mat | 12 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
Absorbent Mat DE 90x60 | Mat | 6.34 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
Absorbent Mat Large | Mat | 12 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
Absorbent Mat Long | Mat | 4.65 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
Absorbent Mat Medium | Mat | 6.34 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
Absorbent [NAME] | [NAME] | 1.17 |  | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3
Admin & Distribution Charge | Misc | 24.92 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Call Charge | Misc | 4.65 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME] | Misc | 1.97 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Environmental [NAME] | Misc | 19.73 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Exchange of Workwear | Misc | 0 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Gloves - Latex Large | Gloves
Gloves - Latex Medium | Gloves
Gloves - Latex P/F Large | Gloves
Gloves - Latex P/F Medium | Gloves
Gloves - Latex P/F X-Large | Gloves
Gloves - Latex Small | Gloves
Gloves - Latex X-Large | Gloves
Gloves - Nitrile  P/F Large | Gloves
Gloves - Nitrile  P/F X-Large | Gloves
Gloves - Nitrile Black P/F Large | Gloves
Gloves - Nitrile Black P/F Medium | Gloves
Gloves - Nitrile Black P/F X-Large | Gloves
Gloves - Nitrile Disposable  Blue | Gloves
Gloves - Nitrile Large Green | Gloves
Gloves - Nitrile Matrix Large | Gloves
Gloves - Nitrile Matrix Medium | Gloves
Gloves - Nitrile Matrix X-Large | Gloves
Gloves - Nitrile X-Large Green | Gloves
Gloves - Vinyl Large | Gloves
Gloves - Vinyl X-Large | Gloves
Land Fill Tax | Misc | 1.98 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Mat-Smart Maxi | [NAME] | 7.81 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Packaging Charge UN3175 | Misc | 0.74 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME] | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME]  Green | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME]  Light Blue | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME]  Light Purple | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME]  Light Red | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME]  Orange | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME]  White | Misc | 0.95 |  | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
Spill Mat 150x30 | [NAME] | 4.65 |  | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3
Spill Mat 200x60 | [NAME] | 12 |  | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3
Spill Mat Medium | [NAME] | 6.34 |  | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3
Spill Mat Mini | Mat | 1.17 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
Spill Mat Small | Mat | 1.54 |  | 0.15 | 0.1 | 0.05 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]   (OP) | Own Product
[NAME](OP) | Own Product
[NAME]   (OP) | Own Product
[NAME] | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Black | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME] | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Green | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Red | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Yellow | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Green | Wiper | 0.35 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]   (OP) | Own Product
[NAME]  Blue | Wiper | 0.19 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME] [NAME] | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME] Superior  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper | 0.2 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper | 0.21 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Blue | Wiper | 0.23 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME] | Own Product
[NAME]   8kg (OP) | Own Product
[NAME]  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper | 0.15 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Green Brown | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green FTR | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME] | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper | 0.17 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME] | [NAME] | 1.5 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
[NAME]  Green | Wiper | 0.7 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME] Superior  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper | 0.47 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper | 0.4 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Blue | Wiper | 0.6 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper | 0.59 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
[NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME] | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
[NAME]  Red | Wiper | 0.44 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - Empty | [NAME] | 2.27 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe Container - Jumbo  Green | Wiper | 0.22 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - Microfibre  Blue | Wiper | 0.25 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - New Jumbo  Green | Wiper | 0.3 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - New Precision  Blue | Wiper | 0.29 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - New Pre-washed [NAME] | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - New Pre-washed Superior  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - New Std  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - New Std  Green | Wiper | 0.15 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - New Std Bagged  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - New Superior  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - New Superior  Red | Wiper | 0.33 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - Precision  Blue | Wiper | 0.26 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Container - Soft Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - Static | [NAME] | 2.27 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe [NAME]  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe [NAME]  Green | Wiper | 0.13 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe [NAME]  Red | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - Std Bagged  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - Superior  Blue | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - Superior  Green | Wiper - Discontinued |  |  | 0.15 | 0.1 | 0.1 | 0.2 | 0.25 | 0.3 | 0.3
Wipe Container - Superior  Red | Wiper | 0.18 |  | 0.1 | 0.06 | 0.03 | 0.1 | 0.15 | 0.2 | 0.25
Wipe Disposable - Critical   Jumbo | Disposable
Wipe Disposable - Critical  Small | Disposable
Wipe Disposable - Offcuts | Disposable
Wipe Disposable - Sheeting | Disposable
Wipe Disposable - Strong White Twin Pack | Disposable
Wipe Frame and 1 Empty Box | [NAME] |  |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe Frame and 2 Empty Boxes | [NAME] |  |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe [NAME] | [NAME] |  |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe Metal Cage | [NAME] |  |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe-Smart Maxi | [NAME] | 7.39 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe-Smart Mini | [NAME] | 3.57 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2
Wipe-Smart Pod and Static Container | [NAME] | 5.21 |  | 0.05 | 0.05 | 0 | 0.1 | 0.1 | 0.15 | 0.2