Combine Column Values + Sequential Number to Create Smart ID Number

I have attached a mocked up version of your worksheet you provided.
I created a new tab called TBL. this is being used for the data validation lists in columns B and C. These are also being used for the vlookups to get the part number.

Column B and C now have a data validation drop down list.
Column D and E have not been touched. Not sure where you get that info from so i assume you manually enter. If need be you can create another drop down list and follow suit.

Column F has the formula:

Formula:

Please Login or Register  to view this content.

This is doing a vlookup on column B and C to the table and then concatenating the answers with column D and E. It then adds the 5 digit number starting at 00001 and increasing in value if there are multiples based on a countif formula and a dynamic range.

dosydos,

Wow. That was fast and does exactly what I wanted it to do. You smart people are great. Column D will have the same drop down as B & C and will have the choice of any number ranging from 04-48 (4 inches to 48 inches). Column E will have drop-downs with the option of 00, 15, 30, 60, 75, 90. If I add the validation drop down list to D & E will it mess up the current equation? It appears that it is only looking for the value of the cell and adding the drop-down wouldn't effect the formula?

I really appreciate your help.

It appears I'm wrong after studying the formula. I need to add vlookup for both columns D & E?

I added the two new data validation lists in column D and E based on lists on the TBL tab. I also updated the formula as it was removing the leading 0 from column D and E, and my guess is you want 5 to actually be shown as 05 in the column F.

new formula

Formula:

Please Login or Register  to view this content.