match function? I don't know what I can apply

[Guest]

Can anyone help?

I have a column (second column) with countries that are in my data; but I
would like to change the names for certain countries to different names
(first column- data that I would like to have for specific countries). I do
not know what formula should I choose for column 1 or hom to arrange (match
or vlookup so it would simply work)

Column1 Column2(data)
Benelux Belgium
Benelux Netherlands
Nordic Denmark
Nordic Finland
Nordic Norway
Nordic Sweden
Russia Russia Exp
UK United Kingdom
France France
Iberia Iberia
Italy Italy

 

[Guest]

Hi,

I am not sure if I am reading the question correctly, but, why don't you use
the find/replace to change the names of the countries in the second column?


Ivan