I have a list of (hundreds of) colors with the numbers we have assigned to them such as:
100n Light red
101n metallic blue
102n transparent red
.
.
.
I created a lookup so that a user can type in a number to see what color it is assigned. I would now like to be able to type in a base color such as "red" and get a list of all possible color numbers (light red, met. red, bright red, etc, etc).
Is there a built in function(s) that I can use to do this? I am fairly comfortable writing VBA code, but I don't want to reinvent the wheel (unless of course there are lots of value added features and high margins - oops got caught up in the marketing spirit).
100n Light red
101n metallic blue
102n transparent red
.
.
.
I created a lookup so that a user can type in a number to see what color it is assigned. I would now like to be able to type in a base color such as "red" and get a list of all possible color numbers (light red, met. red, bright red, etc, etc).
Is there a built in function(s) that I can use to do this? I am fairly comfortable writing VBA code, but I don't want to reinvent the wheel (unless of course there are lots of value added features and high margins - oops got caught up in the marketing spirit).