Possible Vlookup formula? Help?

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 list (in another sheet) of countries which each have a country code in an adjacent column – then insert the code next to the country entered in the first sheet, in a cell in an adjacent column.

so: 

Sheet 1                                       checks                              Sheet 2

Country  Country Code                                                         Country   Country Code

Germany                                                                             Germany DE

 

and insert the country code.

 

Any ideas?

 

Many thanks

By: Chango Mutney

Leave a Reply

Your email address will not be published. Required fields are marked *