Clicky

How To Add Flag Icons To Google Sheets Dynamically

Code In the Video

Wikipedia Flag Selection

=IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(N2," ","_")&"' )]")) ```

Code To Change Abbreviated Country Code To Country Name

=ArrayFormula(UNIQUE(IFERROR( 
           SWITCH(I2, "US", "United States",              
                                "AU", "Australia",
                                "IN", "India",
                                "HK", "Hong Kong",
                                "GE", "Georgia",
                                "TH", "Thailand",
                                "JP", "Japan",
                                "KR", "South Korea",
                                "FR", "France",
                                "BE", "Belgium",
                                "CA", "Canada",
                                "MY", "Malaysia",
                                "SG", "Singapore",
                                "FI", "Finland",
                                "DE", "Germany",
                                "IE", "Ireland",
                                "PH", "Philippines",
                                "IT", "Italy",
                                "ES", "Bandera",
                                "NL", "Netherlands",
                                "NZ", "New Zealand",
                                "AE", "United Arab Emirates",
                                "CH", "Switzerland",
                                "GB", "United Kingdom",
                                "US", "United States",
                                "VN", "Vietnam",
                                "SE", "Sweden",
                                "CO", "Colombia",
                                "HR", "Croatia",
                                "BR", "Brazil",
                                "LT", "Lithuania",
                                "CN", "China",
                                "ZA", "South Africa",    
                                "AT", "Austria", 
                                "DK", "Denmark",
                                "NO", "Norway",
                                "PR", "Puerto Rico",
                                "PT", "Portugal", 
                                "LU", "Luxembourg"  ))))