search for country name and return flag image to cell in Google Sheets
I have a list of countries from 245 countries.
Can I use VLOOKUP in Google Sheets to import the corresponding flags?
I was thinking about potential use of a resource like Wiki or http://www.theodora.com/flags/ but not sure if I can?
+5
source to share
1 answer
Please try this link: https://www.countries-ofthe-world.com/flags-of-the-world.html
Step 1. Get links
=IMPORTXML(A1,"//@src[contains(.,'png')]")
Step 2.Use the picture function
=IMAGE("https://www.countries-ofthe-world.com/"&A5)
+5
source to share