Search and replace function

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top