How to replace a word with a word from other column?
 

I need a modest solution to a spreadsheet where two columns have 4-digit
codes for colors and a requirement to print out the actual color instead of
the code on a label. Since there are hundreds of theses colors to print
daily, I am looking for a macro or function combo that might detect the
4-digit code [ i.e. 01E0 ] and return the color [i.e. Flint] in the column or
fill an adjacent new column with the color. The Edit-Replace function would
work but there are dozens to do every day and then re-do the next day.
Obviously, attempting to automate the process with a macro.

Many thanks in advance for your assistance.

Try a vlookup, IBM (with your "color table" on a separate sheet---even a
hidden sheet):
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"IBM_Honda" wrote in message
...
I need a modest solution to a spreadsheet where two columns have 4-digit
codes for colors and a requirement to print out the actual color instead
of
the code on a label. Since there are hundreds of theses colors to print
daily, I am looking for a macro or function combo that might detect the
4-digit code [ i.e. 01E0 ] and return the color [i.e. Flint] in the column
or
fill an adjacent new column with the color. The Edit-Replace function
would
work but there are dozens to do every day and then re-do the next day.
Obviously, attempting to automate the process with a macro.

Many thanks in advance for your assistance.