Spreadsheet: 847662d1698509251-formula-to-output-certain-value-based-on-text-category-example
Sheet: Sheet1

Code | Item | Item Description | Product Category
SH8500 | [NAME] | Aaliyah 6 Light E14, Semi Flush Brown Oxide / Clear Glass | Home & Garden > Lighting > Lighting Fixtures > Ceiling Light Fixtures
SH8510 | AAL0158 | Aaliyah 10 Light E14, Round Pendant Polished Nickel / Smoke Glass
SH8520 | [NAME] | Aaliyah 16 Light E27, Round Pendant Brown Oxide / Champagne Gold Glass
SH7071 | JAM1707 | [NAME], 2 x 3W LED, 3000K, 238lm, Gold Painted, 3yrs Warranty
SH7072 | [NAME] | [NAME], 2 x 3W LED, 3000K, 238lm, Silver Painted, 3yrs Warranty
SH7073 | JAM3707 | [NAME], 2 x 3W LED, 3000K, 238lm, White, 3yrs Warranty
SH9514BL/AM | HAL4159BL/AM | Halma 8 Light G9, [NAME], Satin Black / Amber | Home & Garden > Lighting > Lamps
SH9514BL/CL | HAL4159BL/CL | Halma 8 Light G9, [NAME], Satin Black / Clear
SH9514BL/SM | HAL4159BL/SM | Halma 8 Light G9, [NAME], Satin Black / Smoke
SH9514BR/AM | HAL4159BR/AM | Halma 8 Light G9, [NAME], Brass / Amber
SH9514BR/CL | HAL4159BR/CL | Halma 8 Light G9, [NAME], Brass / Clear
SH9514BR/SM | HAL4159BR/SM | Halma 8 Light G9, [NAME], Brass / Smoke
SH9514PN/AM | HAL4159PN/AM | Halma 8 Light G9, [NAME], Polished Nickel / Amber
SH9514PN/CL | HAL4159PN/CL | Halma 8 Light G9, [NAME], Polished Nickel / Clear
SH9514PN/SM | HAL4159PN/SM | Halma 8 Light G9, [NAME], Polished Nickel / Smoke
SH7742 | ABB2477 | Abby 4 Light Ceiling, 4 x 5W LED, 4000K, 1700lm, IP44, Polished Chrome, 3yrs Warranty
SH7743 | [NAME] | Abby Wall Lamp Single Adjustable, 1 x 5W LED, 4000K, 415lm, IP44, Polished Chrome, 3yrs Warranty
SH7744 | ABB4477 | [NAME], 3 x 5W LED, 4000K, 1275lm, IP44, Polished Chrome, 3yrs Warranty
SH8215 | ABB5128 | Abby 4 Light Ceiling, 4 x 5W LED, 4000K, 1700lm, IP44, [NAME], 3yrs Warranty
SH8216 | ABB6128 | Abby Wall Lamp Single Adjustable, 1 x 5W LED, 4000K, 415lm, IP44, [NAME], 3yrs Warranty
SH8217 | ABB7128 | [NAME], 3 x 5W LED, 4000K, 1275lm, IP44, [NAME], 3yrs Warranty
SH8218 | ABB8128 | Abby 4 Light Fixed Ceiling, 4 x 5W LED, 4000K, 1700lm, IP44, [NAME], 3yrs Warranty
SH8120 | ALB0218 | Alba Adjustable Linear Bar Spotlight, 4 x GU10 (Max 10W LED), [NAME]/Polished Chrome
SH8150 | ALB0518 | Alba Adjustable Switched Spotlight, 1 x GU10 (Max 10W LED), Oiled [NAME]/Polished Chrome
SH8151 | ALB1518 | Alba Adjustable Round Spotlight, 3 x GU10 (Max 10W LED), Oiled [NAME]/Polished Chrome
SH8152 | ALB2518 | Alba Adjustable Linear Bar Spotlight, 4 x GU10 (Max 10W LED), Oiled [NAME]/Polished Chrome
SH8118 | ALB8118 | Alba Adjustable Switched Spotlight, 1 x GU10 (Max 10W LED), [NAME]/Polished Chrome
SH8119 | ALB9118 | Alba Adjustable Round Spotlight, 3 x GU10 (Max 10W LED), [NAME]/Polished Chrome
SH8310 | [NAME] | Alexis Wall Lamp Small, 1 x 8W LED, 3000K, 640lm, Anthracite/Polished Chrome, 3yrs Warranty
SH8642 | [NAME] | Bolla Medium Oval Ball Flush Fitting 1 Light E27 [NAME] With Frosted White Glass Globe
SH8652 | BOL2568 | Bolla Small Oval Ball Table Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8643 | BOL3468 | Bolla Small Oval Ball Table Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8653 | BOL3568 | Bolla Medium Oval Ball Table Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8644 | [NAME] | Bolla Medium Oval Ball Table Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8654 | BOL4568 | Bolla Small Oval Ball Tall Table Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8645 | BOL5468 | Bolla Small Oval Ball Tall Table Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8655 | BOL5568 | Bolla Medium Oval Ball Floor Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8646 | BOL6468 | Bolla Medium Oval Ball Floor Lamp 1 Light E27 [NAME] With Frosted White Glass Globe
SH8656 | BOL6568 | Bolla Small Oval Ball Wall Light 1 Light E27 [NAME] With Frosted White Glass Globe
SHK0110 | BOX0110 | Box 1 Light Square Ceiling GU10, White Paintable Gypsum With Polished Chrome Cover
SH7140 | [NAME] | [NAME] For 1 Light BOX9317, [NAME]
SHK0111 | [NAME] | Box 2 Light Rectangular Ceiling GU10, White Paintable Gypsum With [NAME]
SH7141 | BOX1417 | [NAME] For 1 Light BOX9317, [NAME]
SH7028 | ROB8207 | [NAME], 1 x 18W LED, 4000K, 1784lm, IP44, Polished Chrome, 3yrs Warranty
SH8178 | ROB8718 | [NAME]/Wall Light, 2 x 3W LED, 3000K, 420lm, 30 Degree, IP65, Grey/Black, c/w 2m Cable, 3yrs Warranty
SH7029 | ROB9207 | Robin 4 Flush Ceiling, 4 x 6W LED, 4000K, 2210lm, IP44, Polished Chrome, 3yrs Warranty
SH8179 | ROB9718 | [NAME]/Wall Light, 1 x GU10 , IP65, Black, c/w 2m Cable, 2yrs Warranty
SH7603 | ROC3067 | [NAME], 1 Light Adjustable E27, [NAME]
SH7604 | ROC4067 | [NAME], 1 Light Adjustable E27, [NAME]
SH7782 | ROM2877 | [NAME] Cross Wall Lamp, 1 x E27, IP54, Anthracite/Clear Glass, 2yrs Warranty
SH7036 | [NAME] | Ronny Wall Lamp, 1 x 8W LED, 3000K, 640lm, Anthracite/Gold Leaf, 3yrs Warranty
SH7037 | RON7307 | Ronny Wall Lamp, 1 x 8W LED, 3000K, 640lm, White/Silver Leaf, 3yrs Warranty
SH7047 | ROS7407 | [NAME], 1 x 18W LED, 3000K, 1620lm, IP44, Smoked/Mirror, 3yrs Warranty
SH7048 | ROS8407 | [NAME], 1 x 18W LED, 3000K, 1620lm, IP44, Amber/Mirror, 3yrs Warranty
SH9000 | ROY0009 | Royal Wall 3 Light E14, Polished Nickel / Cognac Sculpted Glass
SH7382 | VER2837 | [NAME] 10.5cm Square 1 x 10W LED, 3000K, 700lm, [NAME], 3yrs Warranty
SH7383 | VER3837 | [NAME] 10.5cm Square 1 x 10W LED, 3000K, 700lm, [NAME], 3yrs Warranty
SH7384 | VER4837 | [NAME] 10.5cm Round 1 x 10W LED, 3000K, 700lm, [NAME], 3yrs Warranty
SH7385 | VER5837 | [NAME] 10.5cm Round 1 x 10W LED, 3000K, 700lm, [NAME], 3yrs Warranty
SH7386 | [NAME] | [NAME] 10.5cm Round 1 x 10W LED, 3000K, 700lm, [NAME], 3yrs Warranty
SH7387 | [NAME] | [NAME] 10.5cm Round 1 x 10W LED, 3000K, 700lm, Pine Wood, 3yrs Warranty
SH7423 | VIC3247 | Victoria Wall Lamp 1 Light E14, Polished Chrome/Satin Nickel/Clear Crystal
SH7424 | VIC4247 | Victoria Wall Lamp 2 Light E14, Polished Chrome/Satin Nickel/Clear Crystal
SH7425 | VIC5247 | [NAME] 3 Light E14 Polished Chrome/Satin Nickel/Clear Crystal
SH7426 | VIC6247 | [NAME], Polished Chrome & Satin Nickel/Clear Crystal
SH7427 | VIC7247 | [NAME] 8 Light E14 Polished Chrome/Satin Nickel/Clear Crystal
SH7428 | VIC8247 | [NAME] 12 Light E14 Polished Chrome/Satin Nickel/Clear Crystal
SH7551 | VIN1557 | [NAME] 3 Light E27, Brown Oxide/Bronze With Clear Glass Shades
SH7552 | VIN2557 | [NAME] 5 Light E27, Brown Oxide/Bronze With Clear Glass Shades
SH7553 | VIN3557 | [NAME] 6 Light E27, Brown Oxide/Bronze With Clear Glass Shades
SH7554 | VIN4557 | [NAME], Brown Oxide/Bronze With Clear Glass Shades
SH7555 | VIN5557 | [NAME] E27, Brown Oxide/Bronze With Clear Glass Shades
SH7229 | VIN9227 | [NAME], 1 x 3W LED, 3000K, 270lm, IP54, [NAME], 3yrs Warranty