Thank you, but I am not getting that to work. I've got my main sheet with the descriptions and a second tab titled "beads" with a list of beads types (i.e., acrylic, glass, stone, crystal, etc.). The descriptions are around 500 characters. Below is an example of one (ignore the HTML). I want it to pull "stone" out of this string. Any other types of beads in this example, like silver beads, don't matter. I just want the one from the list (always the first type).

I have my workbook set up with a beads tab with all the types in column A in a named table (beads). The second tab is called Description and the description is in Column E, which is not set up as a named table.

"These are simply beautiful Anglican rosary prayer beads. They are handmade with Multi-Colored Picasso Stone and silver beads. They would be a wonderful gift for someone special for Easter, birthdays, Mothers or Father’s Day, new baby gifts, or your local priest or just for yourself. If you require a custom design, these can be made to order completely to your requirements. Simply message me for details.<br><br><p>Features:</p><ul><li>Handmade Item</li><li>Materials: Multi-Colored Picasso Stone and silver beads</li><li>Approximately 10.5 inches long</li><li>Beautiful</li><li>Great gift</li></ul>"

Should you want more examples I can provide that. Thanks very much for your help