I wanna find the most powerful Pokemon in my list. Not the most powerful Pokemon of all time. 'cause we all know it's Pikachu. Well, I'm gonna put in here in B two equals max, and I'm gonna say just look for the max of the C column. Now I could be more specific. I could say C five, and that's going to be the power level here. Now I have that power level, but I wanna know what is the actual Pokemon that has that power level? And I'll put it right here in A two. I could do vlookup . However, VLOOKUP always looks in the first column and to the right. So actually I want to do X lookup. X lookup. X lookup allows me to search for a search key . I'll look up in the C column and I'll. Look at the result in the A column. Now again, I can limit this to C five and a five.

And there we go. We have the most powerful Pokemon in our list here, and if we delete this Pokemon, we find out there's the next most powerful Pokemon. You are 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 gonna be your next Google sheet.