Easier way to do this.
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", "Spain",
"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" ))))