Well, that certainly solves another issue I was going to face. Thank you!

My question was why that formula didn't return "glass" when "glass" was in the string. Most of the others are returning the correct word based on the list on the "Bead" tab, but I couldn't see any reason why it was returning shell if glass was the first bead type in the string.

I'm attaching the actual table that shows some of the correct results. The two formulas that I'm working with are in columns B & C. I can't get either of them to work, but as they do the same thing, I'm mainly working with the one in column C.

I hope that clears up any confusion.

Attached Files

OpenListingsReport08-07-2019_as_table.xlsx (157.8 KB, 8 views)