Spreadsheet: 101184d1299308761-looking-for-formula-to-find-multiple-matching-items-find-matching-skus
Sheet: Sheet1

Item | SKU | Related SKUs | Scents
item 1 | SKU1 | SKU4, SKU6, SKU9 | bergamot, plum blossoms, hinoki wood, patchouli, orris and oriental musks
item 2 | SKU2 |  | Ananas Leaf, [NAME], Apple, Muguet, [NAME], Sandalwood, Cedar & Musk
item 3 | SKU3 |  | Fresh Bergamot, Green Tea, Cedar, Mahogany & Sandalwood
item 4 | [NAME] |  | Tobacco Flower, Clove, Rosewood, Tonka Bean, Dried Fruit
item 5 | [NAME] |  | Bergamot, Jasmine, Violet, Sandalwood, Sweet Broom & White Woods
item 6 | SKU6 |  | Litchi, Freesia, Magnolia, [NAME], Tonka, Teak Essence
item 7 | SKU7 |  | Mandarin, Lemon, French Lavender, Honeysuckle & Ivy Vine
item 8 | SKU8 |  | [NAME], Peony, Sandalwood, Vanilla & Cashmere Woods
item 9 | SKU9 |  | ruby red grapefruit, cassis, jasmine, velvet woods, and tonka bean
item 10 | SKU10 |  | White Tuberose, Ylang-ylang, [NAME], Gardena, Bergamot, Mandarin, Nectarine, and Sandalwood & White Musk
item 11 | SKU11 |  | Rosemary, Pamplemouse, [NAME], Olive Wood, Oakmoss & Patchouli
item 12 | SKU12 |  | Bergamot, Mandarin, Grapefruit, [NAME], Amber Musk & Vanilla
item 13 | SKU13 |  | Feesia, Bergamot, Red Berry, Black Berry, Gardenia, [NAME], [NAME], and Musk
item 14 | SKU14 |  | Mandarin, Violet, Orris, Jasmine, Lilly, Charmomile, Coriander, [NAME], and Tonka
item 15 | SKU15 |  | Bergamot, Lily of the Valley, Patchouli, Amber, White Woods, [NAME], and Cedarwood
item 16 | SKU16 |  | Apple, Mandarin, Lemon, [NAME], Lavender, Orange Flower, [NAME], and Cedarwood
item 17 | SKU17 |  | Tagette, Tahitian Tuberose, Oriental Jasmine, Creme de Vanilla, [NAME], and Musk
item 18 | SKU18 |  | mimosa Blossoms, Bergamot, Palmarosa, Moroccan Rose & Ylang Tea
item 19 | SKU19 |  | White Lotus, Magnolia, Freesia, Patchouli, Clove & Cedarwood
item 20 | SKU20 |  | White Lotus, Magnolia, Freesia, Patchouli, Clove & Cedarwood
item 21 | SKU21 |  | crisp rose, blue hyacinth, delicate jasmine, clove bud and cedar
item 22 | SKU22 |  | Island Gardenia, Rose Petals, Red Jasmine, Lilies & Green Grass
item 23 | SKU23 |  | Island Gardenia, Rose Petals, Red Jasmine, Lilies & Green Grass
item 24 | SKU24 |  | Hibiscus, Tuberose, Fleur d'Oranger, Vanilla & Macadamia Musk
item 25 | SKU25 |  | Hyacinth, White Freesia, Stephanotis, Sea Moss & Cassis Musk
item 26 | SKU26 |  | Tuberose, [NAME], [NAME], Cashmere Woods & Vetyver
item 27 | SKU27 |  | Ivy Leaves, Mandarin, Grapefruit, Anise, Muguet & Sandalwood
item 28 | SKU28 |  | Bergamot, Jasmine, Violet, Sandalwood, Sweet Broom & White Woods
item 29 | SKU29 |  | Litchi, Freesia, Magnolia, [NAME], Tonka, Teak Essence
item 30 | SKU30 |  | Mandarin, Lemon, French Lavender, Honeysuckle & Ivy Vine
item 31 | SKU31 |  | [NAME], Peony, Sandalwood, Vanilla & Cashmere Woods
item 32 | [NAME] |  | ruby red grapefruit, cassis, jasmine, velvet woods, and tonka bean.
item 33 | [NAME] |  | White Tuberose, Ylang-ylang, [NAME], Gardena, Bergamot, Mandarin, Nectarine, and Sandalwood & White Musk
item 34 | SKU34 |  | Rosemary, Pamplemouse, [NAME], Olive Wood, Oakmoss & Patchouli
item 35 | SKU35 |  | Apple, Mandarin, Lemon, [NAME], Lavender, Orange Flower, [NAME], and Cedarwood