R
RichardR
I spent hours trying to get vlookup and replace functions (and other
functions) to do this;
Col A has 2 letter country codes in any order..
Col A
FR
US
GE
I need to do a "simple" lookup from Col M below and replace in Column A
above with the value in Col N (in other words the full country name)
Col M | Col N
FR France
US United States
GE Germany
Thanks
Richard
functions) to do this;
Col A has 2 letter country codes in any order..
Col A
FR
US
GE
I need to do a "simple" lookup from Col M below and replace in Column A
above with the value in Col N (in other words the full country name)
Col M | Col N
FR France
US United States
GE Germany
Thanks
Richard