Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/05/Filter-list-based-on-another-list.xlsx

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