I need some help with a translation from one column to another.
I have 17 Reference that tells what area of the country that buy something. (see column A in the Excel sheet)
Our PO's starts with TJB, TJH, TJC and so on and T! or TX (see column C in the Excel sheet)
Somehow I would like to translate so the first 2 digits in the Column C will be translated to the correct Reference in column A.
TJB XXXXX, TJH XXXX and ALL Of the numbers in column C that starts with TJ should be coded to TODX in column A
The same would go to
All the numbers in column C that starts with T! should be coded to TDE in column A
All the numbers in column C that starts with TX should be coded to XXST in column A
So it is the 2 first digits in column C that needs to be translated somehow. but I do not know how to do it.
I would like to have the translation show up in column B.
I am grateful for all help I can get.
Bookmarks