Google Sheets Pull Data from Another Worksheet Based on Criteria | Use Multiple Criteria Cell Values 

One of the most comprehensive, yet understandable, videos I have watched. Thank you!

Thank you for this clear and easy-to-follow explanation. I like that you gave an entry-level walk-through, then continued to add increasing complexity to help users personalize. The graphics with the shortcuts are a nice touch. A great tutorial in the FILTER function.

Thank you so much for your step-by-step instructions! I feel like I googled everything under the sun until I finally found this video ❤️ exactly what I needed!

Man! What great instructional technique. It makes me want to try stuff that I have absolutely no need for,. but looks cool and easy! WELL DONE!!!

Thank you so much for this. In the first 3 minutes I found what I needed and was able to set up a neat report filter on my first try using your clear example as a model.

Thank you so much. This was so clearly demonstrated. Truly appreciate it.

Truely Amazing. Clear, concise and I learned how to use control keys for ranges!

Hi Chester. Some great techniques shown in this example. Thanks for sharing. Thumbs up!!

love it when you give the keyboard short cuts too. Great work

I really loved your video. Thank you for making such a calm and intelligent instruction. You make it so simple! 💜

I have been searching for this training for weeks so thank you so much!!! You are an amazing instructor! Now I need to figure out how to get "false" from appearing in the rows without data.

Thank you so much I was trying to figure out how to do this and this was perfectly clear and helped out so much!!

Very clear. I'll definitely be having a play this evening

Thank you so much, Sir, for increasing my knowledge...

Very informative and very clean method (by naming the arrays)... Thank you for sharing...

Thank you so much! This was extremely helpful!

Thank you, that was exactly what I was looking for, for almost three hours now, I think I didn't formulate my question correctly while searching, also still new with google sheets, even though I work most of the time with Excel. It was well explained, thank you

That's great! Thanks so much for sharing...

Thanks. Worked perfectly. 🙂

Superb Explanation!!!

You're the BEST teacher 👍. Very well explained 👌. Love your lessons ❤. Subscribed & definately liked. Thank you very much for your time to prepare the best tutorials. Is that possible that you can teach us how to do this on Excel 2016 which does not have the filter fx? thanks a lot👏

thank you!!! exactly what we needed!!

Very well explained.

Soooo helpful! Thank you!!

Exactly what I need - thank you!!

I love Chester, what a great teacher, I get it man!

Thank you very much, your awesome mate!

Omg thank you this is fantastic

Well explained

This is amazing :)

Thank you for the video! If my "transaction" sheet has been created by using importrange from a separate sheet, will this formula still work? Also, I need this to work by looking a column P and Q for a number greater than or equal to 9. Should that still work the same? I seem to missing something...

Hello, thank you for your post. I appreciate all of your work! I have a question and hoping someone can help. Do the column headers need to be exact on the database and query tab for the filter formula to work?

This is an awesome tutorial. Curious if when adding additional records/rows to the primary sheet if the filter will automatically add the new rows to query sheet or if we would have to start over with the process? If re-running the filter will it only bring in new rows or will we end up with duplicates?

beautiful

Thanks for this wonderful explaination! Is it possible to expand the range for transaction_data to empty rows belows to accomodate for future added data?

Hi! This was very helpful -- I'm wondering how I could make a search function that allows me to look for specific data based on multiple conditions. For example, using the template, searching for CASH and VOUCH pay types, that are from a specific store ID, and are above 50 in transaction value. I'm editing a documentary and creating a template to organize my footage.

Thank you, this is super helpful! Is there a way to pull info from multiple sheets onto a single query sheet?

Thanks!

Hello! This was so helpful! What if my value for "payment type" is a number (any number)? I'd like it to populate if any number at all is placed in the Pay_Type cell. In my case it is the quantity that someone is ordering.

Awesome video thank you! Is there a way to sort the results by a certain column without messing up the filter formula?

It is good and well. What if I want get back a step and want to sow everything as the default view? Thanks

Thanks

Thank You, what if you want to sort the Colum by date?

Great video. How would I do this if I need to pull in data from multiple sheets?

very well explained! Im making a spreadsheet with work steps that i have or havent completed. however there is multiple tables which i would like to only show the next 10 i need to do, filtering by a checkmark symbol in one column so signal that i have completed it. But in those filter masks i cannot edit the table, meaning i always need to swap the sheet to change or adjust my next work steps. The only thing im trying to achieve is having an overview of 3 different tables of lists of worksteps where i can edit and only show the latest 10 in those lists, without always needing to delete, hide or move the lines which i have completed or without swapping between sheets. Any idea how i could make such a "dashboard"?

for the product id. Is there away of filtering a dropdown list instead of having to type the 3 letters/numbers in?

Hello, thank you, i have done the copying of the data to a new datasheet. But now i want to remove this from the original datasheet. But cant do this as the new datasheet also updates and data is removed from both sheets. Basically i am creating an inventory record, so when the inventory is used that bin should be empty and available for storing new data

Is there a way of doing this but then also being able to filter by the month as well?

Excellent tutorial. It seems after pulling the data to a new worksheet the data in the new sheet can not be altered, gives and overwrite error.

How did you create the query sheet with the table

Could I Find a pair with the difference 2 using google sheet? Please help me.

How can i do this without having to specify an actual cell? I want to be able to keep adding to my main spreadsheet and if the conditions are met that it copies to the new sheet. The way you have it in your video i have to specify a set range rather than A:Z or something

how automatically send a whole row on another sheet when a cell of another sheet has a specific value in google sheets?

How do I make this dynamic so if I add or delete a row of data from my source worksheet?

i have a question, will the data from the second tab be updated to the first tab automatically?

Hi, Very useful video. Now I would like to automatically sum the rows that are imported. Can anybody explain me how to do that? Of course I can create a formula way down the information, but I would like it to respond automatically to the imported information just one row beneath. Thanks a lot!

I assume Filter() won't work on Excel 2016? It doesn't get recognised

How would you write the formula if you wanted the value to be between 1,000 and 5,000?

sir, may i ask you, how to pull data from another worksheet based on ranged date? thx

Thanks for the tutorial, but I still I didn't get what I'm looking for!! How to fix this { =FILTER(Sheet1!A2:B42,Sheet1!A2:A42=100=>500) }. The numbers are from 100 to 500 and I want to choose any number between it.

Sir, I followed the instructions but I couldn't get the filter data in another sheet, it is showing error "array result was not expanded because it would overwrite data in D8." can you please help me.

How do I use this on multiple sheets.

I think this is what I have been looking for … how can I get some help

I am unsure why but I got a "FILTER has mismatched range sizes" error?

how about summing the total value

Thanks for the tutorial, but I still I didn't get what I'm looking for!! How to fix this { =FILTER(Sheet1!A2:B42,Sheet1!A2:A42=100=>500) }. The numbers are from 100 to 500 and I want to choose any number between it.

I think this is what I have been looking for … how can I get some help