Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video you will learn how to filter for a list of items using a reverse partial match lookup formula. We use the LOOKUP and SEARCH functions to lookup a value and find any partial matches in a list.

We can use this formula in a table and filter the results for all partial matches.

Click here to read the blog post: https://www.excelcampus.com/tips/reverse-partial-match-lookup-filter

This is a continuation of last week's video on how to filter for a list of items. https://youtu.be/GIkcLuL_lrk


This video is from the Filters 101 Course. Please click the link below to learn more about the Filters 101 Online Course.

https://www.excelcampus.com/filters

I also have a free video series on Excel Filters. Here are links to each video.

Video #1 - Overview of Filters: https://youtu.be/cB5koQvGwsA
Video #2 Keyboard Shortcuts for Filters: https://youtu.be/Z1_oq-uPUBU
Video #3 Multiple Column Filters: https://youtu.be/rgATdkyLey8

If you are new to Excel Tables, I have a video on Excel Tables for Beginners: https://youtu.be/fJnJTff4Na8