Paparazzi Consultants with inventory will also tell you that this is a major pain to manage. You need a SYSTEM to get it done right.
That's what this post is about, it's about how to manage your inventory.
=INDEX({"Black", "Blue", "Brass", "Brown", "Copper", "Gold", "Gray", "Green", "Gunmetal", "Multi", "Orange", "Pink", "Purple", "Red", "Rose Gold", "Silver", "White", "Yellow"},MATCH(TRUE,ISNUMBER(SEARCH({"Black", "Blue", "Brass", "Brown", "Copper", "Gold", "Gray", "Green", "Gunmetal", "Multi Colored", "Orange", "Pink", "Purple", "Red", "Rose Gold", "Silver", "White", "Yellow"},B2)),0))