So let's make a searchable dropdown list because whenever we're having a huge list like this, we have just a bunch of YouTube titles. There is something weird that goes on basically at the bottom or top, or anywhere. If all of these are connected, I could start typing fireside. You see, sometimes something comes up. This is fish welfare. But there is literally, if I do command F fireside, there it is fireside. So like sometimes just typing works, sometimes it doesn't. Sometimes I have to do Command F Phish. And if I wanna find something inside here like this, Stephan Schubert, if I go Find Keywords in Any Column. Create quick search dropdown to find keywords Sheet Talking Episode 7: Oz Excel on Fire Bulk Keyword Search Across Many Sites

command F Schubert, yeah, I can find them. But they're all over the place. And if I just. When Schubert, see, there's nothing happening, but let's create a dropdown here in a one and we're gonna get a searchable dropdown because all dropdowns are searchable. Right click. We can create a dropdown , apply to range A one. The criteria for the dropdown . Is not going to be dropdown . It's going to be dropdown from a range. What is that range? It's going to be a four colon A. It's gonna be from the row of a four all the way to the bottom. And we're gonna click done. And so now we have a dropdown. I wanna style this a little differently actually. I want to go and now if we go over here, you can see drop down from range and it has every single. Row there. I'm gonna go to advanced options and I'm gonna say, just give me an arrow, Create a Self-Adding Dropdown Menu Are You Frustrated With Sheets New Dropdown Chips? Bulk Keyword Search Across Many Sites

Dylan, so it's not a chip style. But now if I just double click and do Schubert. Look at that. 1, 2, 3, 4, 5, 6, 7 available. There's one here, probably different spelling. Schubert Schubert Shoe Craft. Oh, that's the extra one there. Or Fish or fireside, or not fireside. There's a bunch of fireside chats. Very, very cool. And now we can just grab one of these. Let's say this one. And if we wanna display the URL here, we do vlookup . This is a simple V lookup. We're going to use this A one as the search key in our range is going to be a four to A, because we don't wanna search for it in A one. SearchLord: One Sheet to Search Them All SearchLord One Sheet to Search Them All

The index is gonna be two. Actually, we need to be A four, colon B. And is it sorted? I don't know. So I'll just put in false. And there is the URL for that video. If I change it, if I go, oh, I want a fireside check. Uh, Pete Singer. There it is. There's a, there's the YouTube video, and if there's nothing here, we get an na. We can just wrap this with if na and do comma nothing or put a little text here, type something. Maybe we'll put a little emoji. Okay. Here's some. Micro Masters program and there's our YouTube video. Pretty cool to make a searchable dropdown right here, and it's so searchable. It's really, really fun. Here, let's see. Everything with climate in the title. Everything there, climate change there. Perfect. Better Sheets Videos Checklist Mr Beast Renames YouTube Titles Bulk Keyword Search Across Many Sites

Thanks. We're watching. 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. Better Sheets Videos Checklist 80 Years In 1 Spreadsheet Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Track Anything! In a Google Sheet