Spreadsheet: 746894d1631102377-long-if-statement-changing-ref-to-one-cell-after-sorting-eg-pre-sorted-_2021-buying-set-up-sheet-third-party-v2
Sheet: A - Price File

SKU | Name | Qty | [NAME] | Value | Cost EUR/USD | Supplier Costs | Weight (kg) | Weight Bracket | Postage UK | Supplier RRP | RRP | Custom Attribute - rrp_usd | MARGIN RRP | GP RRP | Price | Additional Postage US | Price US ROUNDED UP | MARGIN PRICE | GP PRICE | RRP to Price Difference UK | RRP to Price Difference US | % Saving UK | % Saving US | Price Includes VAT | Tax Class | Suppliers | Supplier SKUs | Manufacturer Part Number | UPC | EAN | Product Harmonised Code | Country Of Manufacture | Product Type Description | Detailed Product Type Description | Custom Attribute - brand_type | Custom Attribute - range | Custom Attribute - manufacturer | Category | Custom Attribute - Ignore | GBP > USD Conversion Rate >>> | 1.3 | (working) RRP USD Conversion | (working) Price USD Conversion
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | 20 |  |  |  |  |  |  |  |  |  | Third Party