The error with the spreadsheet result given to you by JonWW is being caused because the country lookup table in Sheet1 has a space after each country code, which is giving odd results. Remove the spaces from after each country code in Sheet1, and itll output the correct lookup results.

Edit:
Heres a (dirtily) fixed sheet
Edit again.. wrong file attached, sorry. Use this:

order_example_countries.zip