View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
new_121 new_121 is offline
external usenet poster
 
Posts: 7
Default help with match? I don't know what formula use

Can anyone help?

I have two columns. In the column2 the data of mine is visible. The column1
contains data that I would like to obtain for specific countries in column2.

Is there any simple formula/ solution that I can apply?

Please help.

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