How to create constructed variables in Excel

[ezkii]

Hi,

I am trying to create product codes and descriptions for products in our retail store and the items have multiple variables.

I wanted to see if there was a way i could put in the variables (colour, material, size, etc) and have excel create all possible combinations of these for me along with a shortened product code based on the variables.

For example:
Variables = |Blind | White, grey, yellow, blue | 50mm, 60mm| Installed, Not-installed|
code abbreviation = |B |W, G, Y, B | 50, 60 | I, NI|

So I wanted it to generate the code - BW50I (and the description) Blind, White, 50mm, Installed - for all possible variables (e.g. BG50I, BY50I, BB50I, BW60I, ETC ETC ETC & DESCRIPTIONS)

I may have not explained it well sorry. I know this is probably way outside the boundaries of what Excel is capable of but just thought i'd ask before i create 5000 product codes manually.

Any help is appreciated.

Thank you