Hi,

I have 3 columns D,E,and F

D will have a list of manufacture names, E will have category Names, and F will have a description of the products.

Example:

D=FOXCONN, GIGABYTE, INTEL
E=MOTHERBOARD
F=GA/1366/I7/X58/3XF/SATA3/USB3

What i am trying to do is search for a specific data value on F description when data value is found replace that value with a value i choose but copy it to E Column after the Category Name on the same row. But it can only search within a particular manufacture and Category which is on column D and E.

Example:

Only search if Manufacture Gigabyte on column d, with the Category Name Motherboard on column e is present. If there present then search and find I7 on column F (match) and then I7 will be replaced with name of choosing which is |Core I7 and joined after Column E MOTHERBOARD

Example Finished:

E=MOTHERBOARD|CORE I7

I have been working on this for awhile and searched everywhere to see if there was example of what i am trying to accomplish. I don't have much experience with VB Macros so your help would be appreciated.