The ISOCOUNTRY() function returns the name and codes for the specified country according to the ISO (International Standard Organisation) standard. Additional data is also available.
Country: Name or country code. If a country code is specified, you must specify the corresponding search type in the "SearchType" parameter.
DataType: Type of data you want to retrieve: 0-ISO country name, 1-numeric code, 2-two-letter code, 3-three-letter code, 4-short country name, 16-phone code, 17-currency name, 18-alphabetic currency code, 19-numeric currency code.
CurrentCell: Reference to the current formula's cell.
[SearchType]: Optional. Search type: 0-country name, 1-numeric code, 2-two-letter code, 3-three-letter code. By default, value 0 is used.
Example Usage
The ISOCOUNTRY() function is simple to use. You just need to specify the name or country code and the type of data you want to retrieve, and Excel (Calc) will automatically return the selected values for the specified country:
=ISOCOUNTRY(Country; DataType; CurrentCell)
We will have the following result:
In this example, the following values are used:
Country:A4 - Country name for which we are searching for information ("Albania").
DataType:E2 - Type of data we want to retrieve: three-letter country code ("3").
CurrentCell:E4 - Cell of the current formula.
Application features
This function performs an approximate search if the country name is misspelled or in a different format. For this, the FUZZYLOOKUP() function is used. If the found value is the result of an approximate search, the cell text will be highlighted in red.
