Uploaded February 2023 | Updated September 2026, 6 minutes ago
Join 300,000+ professionals in our courses: xelplus.com/courses
How can you lookup matches based on a partial match? You might have tried with asterisk but the asterisk doesn't work. The solution is to use the SEARCH and ISNUMBER functions. You can use this combination inside the FILTER function to find partial matches to check if a specific text is included inside other text. So whenever you need to use wildcards inside the FILTER function think of the ISNUMBER and SEARCH combo.
🌍 My Online Excel Courses ► xelplus.com/courses
🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
📚 Excel RESOURCES I Recommend: xelplus.com/resources
🎥 GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Join 300,000+ professionals in our courses: xelplus.com/courses
How can you lookup matches based on a partial match? You might have tried with asterisk but the asterisk doesn't work. The solution is to use the SEARCH and ISNUMBER functions. You can use this combination inside the FILTER function to find partial matches to check if a specific text is included inside other text. So whenever you need to use wildcards inside the FILTER function think of the ISNUMBER and SEARCH combo.
🌍 My Online Excel Courses ► xelplus.com/courses
🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
📚 Excel RESOURCES I Recommend: xelplus.com/resources
🎥 GEAR I use: xelplus.com/resources/#gear
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
Twitter: twitter.com/leilagharani
LinkedIn: at.linkedin.com/in/leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
