Pull Data from Another Sheet based on Criteria in Google Sheets

0:00 Let's pull data from this sheet to another sheet, but only based on certain criteria . We'll create a new sheet here and we'll call it east. Go back to our original sheet. We have order id, customer name, product, region, which we only wanna see the east region in this east here. So let's first just copy the headers if you want those. If you don't even want to copy it, we can just do equals. And then select these headers and then changes this to array formula . And there we have all the headers automatically, so we don't need to copy paste that. If it changes, it'll be updated there. So if we change this to total. Look over here. It'll be total here, but let's get that data .

0:45 Let's pull that data . We'll use filter . We're gonna use the range here of A two to F two we selected, but let's delete that two and get the entire F range A through F, but only the second row. Now we want to filter it by a condition . This is our criteria , and we're going to say the D column. I can even say D two to D. Is equal to, and we'll put in quotes, the word east. Let's end the parentheses there. Hit enter. And now we have east and we see only the east. But what if we wanna make this sort of programmatic or automatic, or like interactive, right? Let's add another row above here and we'll put a dropdown menu right there.

1:33 We will select dropdown menu from a range , and the range will be this region column, let's just say D two downwards. And here are all the options. East, west, north, and south. Click done. Let's go back here. And if we select east, we want east to show up here. So let's say D one is now the criteria . D one. Nothing changes because we've already selected East, but let's select West now and we are now changing all of the data here. We're pulling the data based on this data here. Isn't that cool? And if we have a blank, if we don't have anything, we'll have nothing here, but we can always add if is blank. D one, and if it is blank, we'll say select a region in D one,

2:21 and if it's not blank, we'll actually just go and select it. So now you see to select the region in D one, select that region, and now we have the information. Isn't that cool? We've now pulled this data from this sheet into this other sheet based on the criteria of what region it is. 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.