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

help with match? I don't know what formula use
 

Sounds like you need a lookup table. Check out VLOOKUP in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"new_121" wrote in message
...
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