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

Put this formula in B1:

=VLOOKUP(A1,M$1:N$3,2,0)

and copy down. Then highlight all the cells in column B, click on
<copy then Edit | Paste Special | Values (check) | OK then <Esc. Now
you can Cut/Paste from column B to column A to overwrite the original
values.

Hope this helps.

Pete

On Mar 29, 5:36*am, RichardR
wrote:
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