Excel Filter List Based on Another List | Formula and Advanced Filter Solutions

In this Microsoft Excel video tutorial I explain how to filter a list based on another list. If you are using Excel 365 you can use this combination of functions: XMATCH, ISNUMBER and FILTER. If you have an older version of Excel you can use the Advanced Filter.

Video Table of Contents
00:00 Introduction
00:27 Use the FILTER function
02:52 Use the FILTER with tables
05:27 Use the Advanced Filter

[mohammednafiulislam]

Thank you very much for this tutorial, I searched a lot to solve this porblem which I use to face frequently. This is great, Thank you again

[Sephraes]

This solved a major issue for me. And taking it further, adding NOT() to the front of the ISNUMBER allowed me to find everything that was not on the lookup list. Thank you for your help on this.

[IvanCortinas_ES]

The FILTER function is a real genius created by Microsoft. Thank you Chester!!!

[Chattmandoo]

Exactly what I worked on today, but a little more circumstantial. I have a list of names where some names have a cross in the next column. I want to add these names to a new list. This should be useful for me. Thank you for being so educational.

[jondeaux]

Chester, you've enabled me to look like I know what I am doing.
Thank you for this tutorial.
Subscribed.

[laiwk]

Awesome guide! save my days of work every month!

[ElaineGilsdorf]

WOW!!! Thank you so much for explaining this.

[qzumidz]

Exactly what I'm looking for. Thanks for teaching the filter function.

[mcvbeatz]

Huge help sir. You just helped me streamline a process. Great video

[yarnickmeek]

I have been looking for this all morning! Thanks!!!!

[map]

Clear and concise - helped me greatly. Thank you.

[__Est.her__]

I was looking on cutting down on the time it takes me to make my weekly reports. Using your tutoring it’s pretty much update the source data and send 🎉🎉 thanks

[Jojosmith]

Already subscribed from the first tutorial. Valuable lesson as always. Thumbs up from the beginning class so that I won't forget. Thanks a lot for your teaching ! 👍

[selder_]

Thanks so much. Was worried this wouldn’t work because my like columns were names and not numbers, but it did work. Good to know the different ways to do it and the advantages that come with them

[leixiao]

Thank you very much for this tutorial, it helps me a lot!

[maheshlowe]

Thanks for the video. Saved my day. Keep doing.

[aravindarajchandrasekaran]

wow thanks, this is exactly im looking

[amjadhasan]

For those using advanced filter, you can create a macro while using the advanced filter and create a button assigning that macro.

Now whenever you make a change into the base data, you need to just click the button and it will do the job for you.

[jgsalins]

Very helpful!!!. How to filter data if the list of value are string pattern. For e.g. List of values are ABC, JKL etc, how to do string pattern match in PROD ID column. Thanks in advance!!!

[JamieJackson-zbwf]

Is there a way to use this function but with a sort option? I am using the following =SORT(FILTER(Data_planning, Date_end_date=A2)) but want to sort by a column from the copied data onto the new sheet? For example on the data I am coping I have a price column, I want to sort the copied data by price. Any tips would be greatly appreciated :-) Love your videos!