Spreadsheet: 166194d1341498212-need-to-create-a-dependant-drop-down-controlled-through-2-prior-drop-downs-electrical-price-list-testing-sheet
Sheet: Cable

 |  |  | Price as shown in Cat |  |  |  |  |  |  |  |  |  | Price Per unit [NAME] |  |  |  |  |  | Cheapest
Cat | Manu | Item | 0 | 0 | 1 | 1 | 1 | 1 | VAT Factor | Purchase | Price Reference |  | 6
 |  |  | Toolstation | ScrewFix | TLC Direct | Shop 4 Elec | EIS Ltd | Other |  | Qty |  | Unit | Toolstation | ScrewFix | TLC Direct | Shop 4 Elec | EIS Ltd | Other | Price | Store
Cable |  | Per M   Twin & Earth (6242Y) 1.5mm |  |  | 0.98 |  |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin & Earth (6242Y) 1.5mm | 23.92 | 24.79 | 19.8 | 18.4 |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin & Earth (6242Y) 1.5mm | 42.26 | 47.39 | 36 | 35.02 |  |  | 1.2 | 100
Cable | Generic | Per M   Twin & Earth (6242Y) 2.5mm |  |  | 1.14 |  |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin & Earth (6242Y) 2.5mm | 33.53 | 33.99 | 30 | 27.5 |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin & Earth (6242Y) 2.5mm | 59.51 | 63.49 | 55.2 | 50.04 |  |  | 1.2 | 100
Cable | Generic | Per M   Twin & Earth (6242Y) 4mm |  |  | 1.8 |  |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin & Earth (6242Y) 4mm |  |  | 50.4 | 45.41 |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin & Earth (6242Y) 4mm |  |  | 97.2 | 88.12 |  |  | 1.2 | 100
Cable | Generic | Per M   Twin & Earth (6242Y) 6mm |  |  | 2.64 | 1.38 |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin & Earth (6242Y) 6mm | 79.28 | 83.89 | 72 | 64.64 |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin & Earth (6242Y) 6mm |  |  | 141.6 | 126.26 |  |  | 1.2 | 100
Cable | Generic | Per M   Twin & Earth (6242Y) 10mm |  |  | 4.44 | 2.33 |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin & Earth (6242Y) 10mm | 143.85 | 143.29 | 126 | 110.46 |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin & Earth (6242Y) 10mm |  |  | 240 | 213.42 |  |  | 1.2 | 100
Cable | Generic | Per M   Twin & Earth (6242Y) 16mm |  |  | 5.03 | 3.72 |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin & Earth (6242Y) 16mm |  |  | 195.58 | 174.91 |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin & Earth (6242Y) 16mm |  |  | 377.94 | 339.31 |  |  | 1.2 | 100
Cable | Generic | Per 100m  Twin & Earth (6242B) 1.5mm LSZH | 49.76 | 56.5 | 46.2 |  |  |  | 1.2 | 100
Cable | Generic | Per 100m  Twin & Earth (6242B) 2.5mm LSZH | 71.48 | 85.82 | 67.2 |  |  |  | 1.2 | 100
Cable | Generic | Per 100m  Twin & Earth (6242B) 4mm LSZH |  |  | 104.4 |  |  |  | 1.2 | 100
Cable | Generic | Per 100m  Twin & Earth (6242B) 6mm LSZH |  |  | 153.6 |  |  |  | 1.2 | 100
Cable | Generic | Per 100m  Twin & Earth (6242B) 10mm LSZH |  |  | 259.2 |  |  |  | 1.2 | 100
Cable | Generic | Per 100m  Twin & Earth (6242B) 16mm LSZH |  |  | 394.74 |  |  |  | 1.2 | 100
Cable | Generic | Per M   Twin Brown & Earth (6242YR) 1.5mm |  |  | 0.58 |  |  |  | 1.2 | 1
Cable | Generic | Per 50m  Twin Brown & Earth (6242YR) 1.5mm | 24.74 |  | 19.8 |  |  |  | 1.2 | 50
Cable | Generic | Per 100m  Twin Brown & Earth (6242YR) 1.5mm |  |  | 33.6 |  |  |  | 1.2 | 100
Cable | Generic | Per M   3 Core & Earth ( 6243Y)  1.5mm |  |  | 1.26 |  |  |  | 1.2 | 1
Cable | Generic | Per 50m  3 Core & Earth ( 6243Y)  1.5mm |  | 29.78 | 30 | 27.17 |  |  | 1.2 | 50
Cable | Generic | Per 100m  3 Core & Earth ( 6243Y)  1.5mm |  |  | 54 | 51.49 |  |  | 1.2 | 100
Cable | Generic | Per 50m  3 Core & Earth ( 6243B)  1.5mm LSZH | 37.46 | 48.38 |  |  |  |  | 1.2 | 50
Cable | Generic | Per 100m  3 Core & Earth ( 6243B)  1.5mm LSZH |  |  | 62.28 |  |  |  | 1.2 | 100
Cable | Generic | Per 100m  Singles (6491X)  1.5mm | 17.38 |  | 20.4 | 13.45 |  |  | 1.2 | 100
Cable | Generic | Per 100m  Singles (6491X)  2.5mm | 23.94 |  | 27.6 | 21.98 |  |  | 1.2 | 100
Cable | Generic | Per 100m  Singles (6491X)  4mm | 46.26 |  | 48 | 35.53 |  |  | 1.2 | 100
Cable | Generic | Per M   Singles (6491X)  6mm |  |  | 0.8 |  |  |  | 1.2 | 1
Cable | Generic | Per 50m  Singles (6491X)  6mm |  |  | 34.8 |  |  |  | 1.2 | 50
Cable | Generic | Per 100m  Singles (6491X)  6mm |  |  | 69.6 | 44.24 |  |  | 1.2 | 100
Cable | Generic | Per M   Singles (6491X)  10mm Y/G |  |  | 1.16 | 0.79 |  |  | 1.2 | 1
Cable | Generic | Per 50m  Singles (6491X)  10mm Y/G |  |  | 56.4 |  |  |  | 1.2 | 50
Cable | Generic | Per 100m  Singles (6491X)  10mm Y/G |  |  | 106.8 | 85.26 |  |  | 1.2 | 100
Cable | Wylex | Per M   Singles (6491X)  16mm Y/G |  |  | 2 | 1.42 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Singles (6491X)  16mm Y/G |  |  | 100.2 |  |  |  | 1.2 | 50
Cable | Wylex | Per 100m  Singles (6491X)  16mm Y/G |  |  | 171.6 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Singles (6491X)  25mm Y/G |  |  | 3.72 | 2.23 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Singles (6491X)  25mm Y/G |  |  | 144 |  |  |  | 1.2 | 50
Cable | Wylex | Per M   Singles (6491X)  35mm Y/G |  |  | 4.44 |  |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Singles (6491X)  35mm Y/G |  |  | 189.58 |  |  |  | 1.2 | 50
Cable | Wylex | [NAME] (6181Y) 25mm (pack   1m ) | 9.48 | 10.58 |  |  |  |  | 1.2 | 1
Cable | Wylex | [NAME] (6181Y) 25mm (pack   3m ) |  | 27.18 |  |  |  |  | 1.2 | 1
Cable | Wylex | Per M   Meter Tails (6181Y) 25mm |  |  | 4.54 | 2.87 |  |  | 1.2 | 1
Cable | Wylex | Per M   Meter Tails (6181Y) 35mm |  |  | 6.46 |  |  |  | 1.2 | 1
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 1.5mm |  |  | 1.25 | 0.85 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Three Core swa XPLE (6943X) 1.5mm |  |  | 59.4 |  |  |  | 1.2 | 50
Cable | Wylex | Per 100m  Three Core swa XPLE (6943X) 1.5mm |  | 110.29 | 111.6 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 2.5mm |  |  | 1.85 | 1.16 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Three Core swa XPLE (6943X) 2.5mm |  |  | 85.2 |  |  |  | 1.2 | 50
Cable | Wylex | Per 100m  Three Core swa XPLE (6943X) 2.5mm |  |  | 156 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 4mm |  |  | 2.28 | 1.57 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Three Core swa XPLE (6943X) 4mm |  |  | 101.4 |  |  |  | 1.2 | 50
Cable | Wylex | Per 100m  Three Core swa XPLE (6943X) 4mm |  |  | 187.2 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 6mm |  |  | 2.94 | 2.12 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Three Core swa XPLE (6943X) 6mm |  |  | 137.4 |  |  |  | 1.2 | 50
Cable | Wylex | Per 100m  Three Core swa XPLE (6943X) 6mm |  |  | 262.8 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 10mm |  |  | 5.46 | 3.38 | 3.24 |  | 1.2 | 1
Cable | Wylex | Per 50m  Three Core swa XPLE (6943X) 10mm |  |  | 248.4 |  |  |  | 1.2 | 50
Cable | Wylex | Per 100m  Three Core swa XPLE (6943X) 10mm |  |  | 469.2 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 16mm |  |  | 7.09 | 5.17 |  |  | 1.2 | 1
Cable | Wylex | Per 50m  Three Core swa XPLE (6943X) 16mm |  |  | 333 |  |  |  | 1.2 | 500
Cable | Wylex | Per 100m  Three Core swa XPLE (6943X) 16mm |  |  | 627.6 |  |  |  | 1.2 | 100
Cable | Wylex | Per M   Three Core swa XPLE (6943X) 25mm |  |  |  |  |  |  |  | 1