How to Pull Data from Another Sheet based on Criteria in Excel & Google Sheets?

Learn how to pull data from another worksheet (aka sheet, tab) based on criteria in Excel & Google Sheets.

#excel #googlesheets

[fittolast]

Thanks so much for your videos. You explain complex matters really easily, and I'm finding the info incredibly helpful!

[JohnDeir]

Good Tutorial and I use filter function a lot. And I learned to add a second filter function to wrap the first filter function to pick the columns I only needed. And on one of my sheets I made a relationship of checkboxes to choose the columns I wanted. I find the filter function to have a lot of uses. Thanks for all the tutorials!!!

[rulouri]

Thanks!!! I was struggling like mad since yesterday night to come up with a solution for this. I am entering data into a sheet that sums up the company's total expenses, but the expenses are made based on multiple projects. First I used filters, but this gets pretty daunting as the data multiplies. I was looking for a way to split the information according to each project in different tabs so I can see the expenses for each without having manually filter, or risk losing data while using copy-paste each time I have an entry. Your explanations are short, easy to follow, and very clear. Thank you!

[tff]

Quick and easy to follow explanation! I was searching and kept coming up with other solutions that didn't meet my needs. Yours did thank you!

[johnwjohnson]

Thank you for posting this. I was at a loss as I'm creating a CRM using Google Sheets and this helped me tremendously with this issue. No other video I came across had this exact issue!

[ivanurbina]

Love it. Another feature I just learned existed. This works for the project I have in mind. Thank you so much!!!

[ryderoreilly]

Perfect - I've been searching for a formula for the last 3 hours!!! and this works!!

[liliboggess]

Thank you so much! This was so helpful to help me sort commission rule data and customize it to the type of sale my employees did! I am forever grateful!

[faithfulfungi]

You just saved me at leasr 5 hours of manual work. Thank you so much!!

[sudoalex]

Thanks to your previous video about filter functon I was able to make a huge filter thing and my favorite thing is that you can combine different filters putting them all into an array like ={filter(A2:B30, A2:A30="male"), filter(G2:L30, G2:G30>30)} and even sort that range from columns It's insanely useful!

[InsightKnowlege]

Hi mate. You’re videos are great. Easy to understand and very comprehensive. You just earned a subscriber. 🎉
I am looking on how to map specific columns in two separate sheets. So if you have any video on this please share a link otherwise would appreciate if you create a video on this topic. Thanks once again and keep it up. Ta

[siddharthjain]

It was basic video. I have seen a seprate video of filter function on youtube it was a great video. You are doing great job. Keep doing it is sirji.
I appreciate and admire your work

[MiroCro]

This was very simple and useful. Thank you!

[rhettdopwell]

Thank you very much. You helped me to succeed with my project in about 1 minute of your video. Awesome.

[christypropst]

Thank you! This was the best and helped me so much. I was able to link data sheets for easy editing and viewing for my staff.

[wumbo]

This is what I need now, this is super helpful. Thank you, glad to find your video.

[jacksonbmx]

Sou super grato ao canal! Queria saber como faço uma ordenação que parece ser básica mas não é lol. Em outro momento eu digo qual é...

Thank you for vídeo!!!!

[deinesrojas]

You have no idea how much you just helped me! Thanks for the video.

[stepansargsyan]

Thank you so much, this video helped us to save a lot of time :) Just one question what if we need to populate the cells with a similar word not exactly the same?

[trinaharris]

Great video; I have a similar need and having issues. I want to compare names from from sheet and where the names matches, add the data for the phone number in a cell . Any suggestion on what option I should use?