I have an excel file that stores an image of each style of garment that we are producing for the current season. A number of staff access this file to get a copy of the image to put into other excel files.
There are approximately 250 styles, each belonging to one of three labels.
In Column C is a Style number that is prefixed with a letter to show which label the garment belongs to. The Prefix is equal to the first letter of the name of the label. So if we had a label called ACME, the style number would be prefixed with an