VBA - Making corresponding descriptions to product ID's.

**redbull** · 05-30-2012, 03:04 PM

Greetings, this is my first post on Excel Forum and I am happy to be here! I would appreciate it if those reading this would please take the time to spread your Excel knowlege with a newcomer.

.

An example of an ordering code in cell A1 is - 4W/G12N9DA
corresponding description in B1 - 4-Way, 12VDC Solenoid Operated, Concealed Manual Override, w/o Locating Hole, 1/2"NPT Terminal Box

in this case, 4W = 4-way
G12 = 12VDC Solenoid Operated
N9 = Concealed Manual override
absense of /62 = w/o locating hole
DA = 1/2' NPT Terminal Box

and so forth....

Can somebody help me with a function or procedure in VBA where column A is searched for these codes and a resulting description is the output in the adjacent cell? Preferably conjoined separated by commas with Concatenate.

I have basic VBA knowlege and a head start and writing such a program would save me countless hours due to the thousands of rows I am dealing with. Thank you!

**AlvaroSiza** · 05-30-2012, 03:57 PM

Few things:

1. It would help your cause to post a sample workbook stripped of sensitive information.
2. How many different codes are there and where do their descriptions reside in the workbook?
3. Should every single occurance of a Column A code be checked for the absense of /62?
4. Are the codes always ordered as you presented 2 digit code > 3 digit code > 2 digit code > 2 digit code, or will they be different?

**redbull** · 05-30-2012, 04:36 PM

1. I made a much more simple excel sheet for you to look at. It explains what is neccessary. excel program.xls
2. I will make a separate sheet for the codes with the corresponding description
3. Every occurance should be checked
4. They will be different