Search and replace function

[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

 

[Pete_UK]

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