Hello, i am needing some suggesting and code examples. I have a list in
sheet 2 with 3 columns. (desc, desc2, and desc3). I would like to take
my string to search in sheet 1 [Cells(x,13).value] look for the match
in sheet 2 list, however it could be found in either 1st or 2nd column.
if it's found in column 2, i want to use the value in column 1 to be
the replacement in sheet 1 [Cells(x,13).value], if it's found in column
1 then just leave it alone. Also, there might be a 'blank' value in
[cells(x,13)], if so i just want to leave it alone, or actually want to
add the code:[Cells(i, 13).Interior.ColorIndex = 6].

I was thinking of another solution in the post Loops, ranges and
vlookup... but, i think if i just change the value to the primary or
[column 1] of the list in sheet 2, then i can use the vlookup easily.
I think that would be easier to accomplish than the previous post.

Any suggestions would be most helpful.


Keri~