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

G

Guest

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
 
B

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)
 

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

Similar Threads

match function? I don't know what I can apply 1
help with formula 5
[email protected] 2
can anyone suggest me any other fax services that you have been used? 0
vlookups 0
Bargain Nice one Voip 3
User Form issue 5
Password Agent - almost freeware, almost since people in countries with the highest living standards 9

Top