Spreadsheet: 173907d1344852054-2-colums-of-data-trying-to-specify-cheapest-one-of-groups-by-matching-names-example-variant-defaultwithcode
Sheet: Sheet1

[NAME] |  | Price
 |  | 79.92
 |  | 64.425
 |  | 659.925
 |  | 524.925
 |  | 15.92
[NAME] 1000w Tungsten Halogen Tube - Box of 25 (110 or 240v) |  | 56.925
[NAME] 1000w Tungsten Halogen Tube - Box of 25 (110 or 240v) |  | 56.925
 |  | 19.12
 |  | 3.12
 |  | 3.12
 |  | 3.12
 |  | 2.16
 |  | 19.12
 |  | 6.32
 |  | 7.6
 |  | 5.2
 |  | 25.52
[NAME] 1500w Tungsten Halogen Tube - Box of 25 (110 or 240v) |  | 59.925
[NAME] 1500w Tungsten Halogen Tube - Box of 25 (110 or 240v) |  | 59.925
[NAME] 150w Tungsten Halogen Tube - Box of 25 (110 or 240v) |  | 23.925
[NAME] 150w Tungsten Halogen Tube - Box of 25 (110 or 240v) |  | 23.925
[NAME] (110 or 240v) E85415/405 |  | 68.72
[NAME] (110 or 240v) E85415/405 |  | 68.72
 |  | 36.72
 |  | 28.72
 |  | 22.32
 |  | 35.12
 |  | 7.92
 |  | 12.72
 |  | 28.72
 |  | 3.12
 |  | 3.12
 |  | 3.12
 |  | 2.16
 |  | 19.12
 |  | 6.32
 |  | 7.6
 |  | 5.2
Defender 25mtr Cable Extension Reel 110v/16a E86450/55 |  | 35.12
Defender 25mtr Cable Extension Reel 110v/16a E86450/55 |  | 47.92
 |  | 35.12
 |  | 277.425
 |  | 64.425
 |  | 89.925
[NAME] 300w Tungsten Halogen Tube - Box of 50 (110 or 240v) |  | 49.425
[NAME] 300w Tungsten Halogen Tube - Box of 50 (110 or 240v) |  | 49.425
Defender 32amp Socket Tester (110 or 240v) E85420/410 |  | 71.92
Defender 32amp Socket Tester (110 or 240v) E85420/410 |  | 71.92
 |  | 149.925
 |  | 194.925
 |  | 487.425
 |  | 7.92
[NAME] 500w Tungsten [NAME] with Bulb, Cable & Plug (110 or 240v) |  | 14.32
[NAME] 500w Tungsten [NAME] with Bulb, Cable & Plug (110 or 240v) |  | 14.32
[NAME] 500w Tungsten Halogen Swing-Leg Tripod Flood Lights (various options) |  | 27.12
[NAME] 500w Tungsten Halogen Swing-Leg Tripod Flood Lights (various options) |  | 39.92
[NAME] 500w Tungsten Halogen Swing-Leg Tripod Flood Lights (various options) |  | 27.12
[NAME] 500w Tungsten Halogen Swing-Leg Tripod Flood Lights (various options) |  | 39.92
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 30.32
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 41.52
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 30.32
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 41.52
[NAME] 500w Tungsten Halogen Tube - Box of 50 (110 or 240v) |  | 49.425
[NAME] 500w Tungsten Halogen Tube - Box of 50 (110 or 240v) |  | 49.425
 |  | 404.925
 |  | 34.2
 |  | 22.2
 |  | 30.77142857142857
 |  | 472.425
 |  | 18.77142857142857
 |  | 25.62857142857142
 |  | 55.425
 |  | 56.925
 |  | 65.925
 |  | 44.925
Defender Distribution Unit / [NAME] 16amp (110 or 240v) E13104/112 |  | 23.925
Defender Distribution Unit / [NAME] 16amp (110 or 240v) E13104/112 |  | 23.925
 |  | 194.925
 |  | 134.925
 |  | 549.1764705882352
 |  | 662.1176470588235
 |  | 958.5882352941177
Defender ECO UPLIGHT Portable 4ft Fluorescent Light (110 or 240v) E712600/610 |  | 59.925
Defender ECO UPLIGHT Portable 4ft Fluorescent Light (110 or 240v) E712600/610 |  | 59.925
Defender Encapsulated Fluorescent Light Fittings Only (various options) |  | 28.425
Defender Encapsulated Fluorescent Light Fittings Only (various options) |  | 28.425
Defender Encapsulated Fluorescent Light Fittings Only (various options) |  | 19.425
Defender Encapsulated Fluorescent Light Fittings Only (various options) |  | 19.425
 |  | 74.925
 |  | 1.090909090909091
[NAME] String Site Lighting 100mtr 110v (various options) |  | 123.5636363636364
[NAME] String Site Lighting 100mtr 110v (various options) |  | 101.7454545454545
[NAME] String Site Lighting 100mtr 110v (various options) |  | 123.5636363636364
[NAME] String Site Lighting 100mtr 110v (various options) |  | 101.7454545454545
[NAME] String Site Lighting Kit 22mtr 110v (ES or BC fittings) E89810/20 |  | 44.925
[NAME] String Site Lighting Kit 22mtr 110v (ES or BC fittings) E89810/20 |  | 44.925
Defender Floor / Carry Light 38w Fluorescent (110 or 240v) E709155/150 |  | 30.32
Defender Floor / Carry Light 38w Fluorescent (110 or 240v) E709155/150 |  | 30.32
Defender Fluorescent Battery Back-Up Work Lights on Fixed [NAME] 110v (2ft or 5ft) |  | 149.925
Defender Fluorescent Battery Back-Up Work Lights on Fixed [NAME] 110v (2ft or 5ft) |  | 134.925
Defender Fluorescent Work Lights 2ft on Fixed [NAME] (110 or 240v) |  | 52.425
Defender Fluorescent Work Lights 2ft on Fixed [NAME] (110 or 240v) |  | 52.425
Defender Fluorescent Work Lights 2ft on Fixed [NAME] (110 or 240v) |  | 59.925
Defender Fluorescent Work Lights 2ft on Fixed [NAME] (110 or 240v) |  | 59.925
Defender Fluorescent Work Lights 5ft on Fixed [NAME] (110 or 240v) |  | 52.425
Defender Fluorescent Work Lights 5ft on Fixed [NAME] (110 or 240v) |  | 52.425
Defender Fluorescent Work Lights 5ft on Fixed [NAME] (110 or 240v) |  | 59.925
Defender Fluorescent Work Lights 5ft on Fixed [NAME] (110 or 240v) |  | 59.925
Defender Fluoresecent Contractors Lights 2ft (110 or 240v) |  | 44.925
Defender Fluoresecent Contractors Lights 2ft (110 or 240v) |  | 49.425
Defender Fluoresecent Contractors Lights 2ft (110 or 240v) |  | 49.425
 |  | 11.12
 |  | 11.12
 |  | 11.12
 |  | 15.92
 |  | 15.92
 |  | 17.52
 |  | 17.52
 |  | 8.485714285714286
 |  | 8.485714285714286
[NAME] 110v Yellow Arctic Cable 100mtr Drum (various options) |  | 59.925
[NAME] 110v Yellow Arctic Cable 100mtr Drum (various options) |  | 97.425
[NAME] 110v Yellow Arctic Cable 100mtr Drum (various options) |  | 89.925
[NAME] 110v Yellow Arctic Cable 100mtr Drum (various options) |  | 134.925
[NAME] 110v Yellow Arctic Cable 100mtr Drum (various options) |  | 172.425
[NAME] 230v Blue Arctic Cable 100mtr Drum (various options) |  | 59.925
[NAME] 230v Blue Arctic Cable 100mtr Drum (various options) |  | 97.425
[NAME] 230v Blue Arctic Cable 100mtr Drum (various options) |  | 74.925
[NAME] 230v Blue Arctic Cable 100mtr Drum (various options) |  | 134.925
[NAME] 230v Blue Arctic Cable 100mtr Drum (various options) |  | 209.925
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 47.925
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 67.425
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 97.425
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 59.925
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 82.425
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 127.425
[NAME] Black Rubber Cable 50mtr Drum (various options) |  | 209.925
 |  | 46.32
Defender Heavy Duty 50mtr Cable Extension Reel 110v/16a E86500/10 |  | 57.52
Defender Heavy Duty 50mtr Cable Extension Reel 110v/16a E86500/10 |  | 79.92
 |  | 54.32
 |  | 31.92
 |  | 17.52
Defender LED Festoon String Lighting 22mtr (110 or 240v) E89336/39 |  | 55.425
Defender LED Festoon String Lighting 22mtr (110 or 240v) E89336/39 |  | 55.425
 |  | 116.2909090909091
Defender LED Floor / Carry Light (110 or 240v) E709185/180 |  | 30.32
Defender LED Floor / Carry Light (110 or 240v) E709185/180 |  | 30.32
 |  | 41.925
Defender LED Multi-Position Telescopic Task Light (110 or 240v) |  | 49.425
Defender LED Multi-Position Telescopic Task Light (110 or 240v) E712700 |  | 49.425
 |  | 31.92
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 17.05714285714285
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 13.62857142857143
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 23.91428571428571
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 17.05714285714285
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 17.05714285714285
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 13.62857142857143
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 17.05714285714285
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 25.62857142857142
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 15.34285714285714
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 13.62857142857143
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 23.91428571428571
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 25.62857142857142
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 41.05714285714286
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 41.05714285714286
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 29.05714285714285
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 25.62857142857142
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 29.05714285714285
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 39.34285714285714
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 41.05714285714286
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 42.77142857142857
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 42.77142857142857
Defender Loose Cable Extension Leads with Fitted Plug & Socket (various options) |  | 59.91428571428571
 |  | 2720.454545454545
[NAME] 500w Tungsten Halogen Magnetic Flood Light (110 or 240v) |  | 31.92
[NAME] 500w Tungsten Halogen Magnetic Flood Light (110 or 240v) |  | 31.92
 |  | 9.342857142857143
[NAME] [NAME] Tungsten Halogen Floor / Carry Flood Light (110 or 240v) |  | 14.32
[NAME] [NAME] Tungsten Halogen Floor / Carry Flood Light (110 or 240v) |  | 14.32
 |  | 74.925
 |  | 12.72
 |  | 55.92
 |  | 55.92
 |  | 14.32
 |  | 67.425
 |  | 67.425
 |  | 67.425
 |  | 74.925
 |  | 28.72
Defender Scaffold Gripper 500w Tungsten Halogen Flood Light (110 or 240v) |  | 27.12
Defender Scaffold Gripper 500w Tungsten Halogen Flood Light (110 or 240v) |  | 27.12
[NAME] Unit 4-Way 16amp (110 or 240v) E13200/10 |  | 29.925
[NAME] Unit 4-Way 16amp (110 or 240v) E13200/10 |  | 29.925
 |  | 19.425
[NAME] [NAME] 3-Way [NAME] (various options) E13240/30/45 |  | 19.425
[NAME] [NAME] 3-Way [NAME] (various options) E13240/30/45 |  | 19.425
[NAME] [NAME] 3-Way [NAME] (various options) E13240/30/45 |  | 23.925
Defender UPLIGHT V2 Portable 2ft 18w Fluorescent Light (110 or 240v) E712564/566 |  | 74.25
Defender UPLIGHT V2 Portable 2ft 18w Fluorescent Light (110 or 240v) E712564/566 |  | 74.25
Defender UPLIGHT V2 Portable 4ft 36w Fluorescent Light (110 or 240v) E712560/562 |  | 81
Defender UPLIGHT V2 Portable 4ft 36w Fluorescent Light (110 or 240v) E712560/562 |  | 81
 |  | 209.925
 |  | 374.925
[NAME] 500w Tungsten Halogen Floor / Carry Flood Light (110 or 240v) |  | 12.72
[NAME] 500w Tungsten Halogen Floor / Carry Flood Light (110 or 240v) |  | 12.72
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 23.92
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 30.32
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 23.92
[NAME] 500w Tungsten Halogen Tripod Flood Lights (various options) |  | 30.32
 |  | 39.92
 |  | 39.92
 |  | 39.92
 |  | 39.92