Hi all, I am having trouble figuring out generate a SKU based on selected conditions. Here is the detailed problem:

Basically I have a 15 character SKU and each character is dependent on a selection of an assembly. For example, The first letter in the SKU is representative of the unit type, so If had a drop down box with 5 choices of unit type, the first letter of the SKU would change based on my selection. Ok, thats the easy part (I could just use IF statements). Now we move to the second selection (which also has 5 different options). So right now lets say after one selection my SKU looks like this:

BXXXXX-XXXXX-XXXXX

Now the first selection can be coupled with another 5 different selections and the amount of options get exponentially greater. So if I chose option 1(B) in the first dropdown box, and option 1(Z) in the second dropdown box, it would look like this:

BZXXX-XXXXX-XXXXX

but now I have other combinations that simply cannot be satisfied due to the limited amount of nested IF/AND statements, and as you can see as I move into more and more options there are going to be hundreds of different combinations. Is there an easy way to go about this?? Any help would be greatly appreciated!

P.S. I'm sorry if there is another topic on this, but I couldn't decipher which one would pertain to my problem specifically...