Urgent help needed with formula for a template! Advice much appreciated!

[changomutney]

Hi guys,
I am relatively inexperienced with Excel formulas but I am trying to create a formula for a template for others to use. The idea is that they will enter the country name in one column and the formula will check the country against the list (in another sheet) of countries which each have a country code in an adjacent column – the formula will then recognize the country, take the the country code and insert it next to the country entered in the first sheet, in a cell in an adjacent column. This would mean that people using the template don't have to manually check the country against the list and insert the code themselves.
so:
Sheet 1 checks Sheet 2
Country Country Code Country Country Code
Germany Germany DE

and insert the country code.

Any ideas?

Many thanks

 

[Gilliam]

so a VLOOKUP?
kind of like...
=IFERROR(VLOOKUP(< country entered in sheet 1 > , < range with countries and country code listed on sht2 > , 2 , false),"Country not listed")

 

[Oeldere]

Use Vlookup for that kind of work.

 

[changomutney]

Vlookup would be right on the money to find the country in the second sheet, but I also need it to take the country code next to it and insert it into a column in the first sheet.

so take Germany.

The person types in Germany in sheet 1

Country Country Code
Germany

the formula finds Germany in sheet 2, takes the country code in the column next to it
Country Country Code
Germany DE

and populates the empty column in sheet one

Country Country Code
Germany DE

 

[Oeldere]

As already given as solution, VLookup will do that for you.

See for the syntax of Vlookup with the help function (F1).