View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Search and translate

I need to search a column for specific characters and "translate" the
characters into meaningful explanations in the next column.
i.e. Column A, cells 1 thru 5 have the following characters
1,2,3
1,2
2
1,3
2,3

I need to "translate" these codes to be meaningful, so column B, cells 1
thru 5 would read:
red, green, black
red, green
green
red, black
green, black

Any Ideas?
Thx, Matt