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.
Sheet 1 checks Sheet 2
Country Country Code Country Country Code
Germany Germany DE
and insert the country code.
By: Chango Mutney