How to Check if Cell Contains Specific Text from a List | Partial Match Excel Tutorial
Learn the first steps to optimize any spreadsheet: https://www.excelpowerup.com/training
Take your Excel spreadsheets to the next level: https://www.excelpowerup.com/course
Get personalized professional support: https://www.excelpowerup.com/support
In this video, I reveal a simple yet dynamic method to automate text analysis. This approach can save you countless hours by using a formula to check if a cell contains specific text from a list. The functions we will use are TEXTJOIN, FILTER, ISNUMBER, and SEARCH.
Note: The dynamic array formulas TEXTJOIN and FILTER are available in Excel 2019, Excel 2021, Excel 365, and Excel for the web.
Website: https://www.excelpowerup.com
Instagram: / rebekahoster
TikTok: / rebekahoster
LinkedIn: / rebekah-oster
00:00 Introduction
00:45 SEARCH Function
03:33 ISNUMBER Function
04:26 FILTER Function
06:31 TEXTJOIN Function
08:37 The Formula is Dynamic!
