 In a previous video, I showed you how to auto populate based on a list using the lookup. You can also do it using index and match. As a reminder, you could, for instance, do data validation, allow a list, and for your source you could do this entire country list. And now you would have, wherever it was that I put that way up here, you would have these countries. And then we could auto populate this cell with the capital based upon this choice. That's a different video. This user had a question, which is, well, how do you get this list to autocomplete? So different than auto populate is autocomplete. And so, for instance, if I wanted Brazil to show up in here, it doesn't. Even if I hit enter, it just says it doesn't match and you have to type out the entire country. So the question is, how can you autocomplete this? Well, to make this easier on me, I am going to control, shift down on these countries. And I'm going to title this entire list country so that it's easier to refer to later. Great. And now I'm going to take advantage of something. First of all, let me just get rid of that list. I'm going to take advantage of the fact that Excel will autocomplete based upon what is directly above you. And so here, what I'm going to do is take this entire list, control, shift up, down one. And I am going to set these row heights to zero so that they're all hidden. Now, of course, you'll notice that we're starting online 250. But what I can do now is come back to my data validation and I can allow a list. And I'm going to allow that whole list of countries. So now I have this list here that I want. But the other thing I can do is take advantage of the fact that now that those cells above me are the name of the countries, it will autocomplete once you get to enough letters that it can differentiate. So I get to BRA. It knows that it's going to be Brazil. Some of them you might have to go further. For instance, China isn't going to populate until you get to the end. The Americas populate right there. And then, of course, you could use the VLOOKUP tutorial to auto populate the capital. That helps.