Spreadsheet: 802446d1666861619-nested-vlookup-and-ifs-test-for-excel-forum-2
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% +
[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