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

[new_121]

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

 

[Bob Phillips]

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)