Hi,
I'm running a vlookup in order to change a column of nationality to country name via vlookup.
Therefore I am looking for a table including all 192 in columns of a) nationality and b) country like this:
Afghan / Afghanistan
Albanian / Albania
Algerian / Algerian
....
Anyone out there having an idea about where to find this?
Thanks in advance!
Anders
Second hit in Google for "country nationality names"
http://geography.about.com/library/weekly/aa030900a.htm
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks