Enter country code when country name is found

[sven_01]

Hi,
I want to have a formula that looks through a range of cells, and if a country is listed ( i.e United States) in a cell, then it will enter the 2 letter code in another cell (i.e US).
This would apply for approximately 70 countries.

 

[alansidman]

Build a table with the names of the seventy countries in one column and their 2 letter code in the next column.

Use the Vlookup function in your spreadsheet to find the 2 letter code. If you are unsure of the vlookup function, then go to https://www.techonthenet.com/excel/formulas/vlookup.php

 

[sven_01]

Thanks, but how do i deal with the instances where a country appears multiple times in the list. I did a vlook up formula but it did not work for multiple entries .Can anyone provide me the actual formula if the full list of countries runs from A1 through to A90 ( multiple occurrence of same country), where the table listing all countries is in E1 through to E70, and the matching country codes are in F1 through to F70 (country in E1 has matching 2 letter code in F1 and so on.)
thanks in advance.

 

[alansidman]

Look at this link and the UDF for multiple results on a lookup

http://www.excelfox.com/forum/showthread.php/4-Vlookup-to-Return-Multiple-Values?highlight=mlookup

 

[sven_01]

Thanks again Alansidman.
Sorry, but my excel experience is limited, and looking at this link didn't help me at all. (probably says a lot for my excel ability) Was hoping for the actual formula I could insert given the parameters in my 2nd post and the cells I provided.... can you / anyone else assist?