Hello,

I'm a basic user of excel and I wondered if you could help me. I would like to do the following:

Using the attached data as an example, I want to take the string in column C (product codes) and create a string in column D (of product ID's) by looking up the individual product codes from column C (seperated by coma's) in column A and getting there relevant ID's from column B and creating a string that will sit in column D (seperated by colon's, no spaces).

I would be greatful for any help with this as I am struggling on how to go about this.

Thanks in advance.

Paul