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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
User Form issue 5
Bargain Nice one Voip 3
One bar chart 2

Back
Top