Use VLOOKUP to Add Flag to Google Sheets
Learn how to use VLOOKUP in Google Sheets to dynamically add country flags using ISO codes and an API. This tutorial provides step-by-step instructions for creating a visually appealing flag display in your spreadsheets.
I want to add the flag to each of these countries. I have over here the ISO twolet combination code for each country. And I could get that letter code by just doing equals vookup searching the key of the country the range ISO tab A B and I'm looking for that second or number two index . I'm going to say it's not sorted for now. And now that's just going to get me the code. But I want to put that code into a URL and get the flag. So I'm going to do image and that URL is going to be in here. I'm going to add an amperand and get that VLOOKUP . But that URL is going
to be flags API.com slash. Now I'm going to insert the ISO code and then do an amperand and continue the URL slashflat64.png. I'm going to end parenthesis and hit enter. It's going to ask me to allow access . And there it is. Can center it up. And now I can copy and paste this. and it'll load each of the count's flags because it's looking for this country ISO code and then putting it into flags.com and then /flat 64.png. If I want a shiny flag, I can do shiny. And there's all the shiny flags for any country. You're watching Better Sheets here on YouTube.
Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how-tos, get more out of your Google Sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is going to be your next Google Sheet.