Forum Discussion
Using the FILTER Function
I have a spreadsheet with a long list that I need to search to determine if a specific word or term is included in the list. In some cases, I want to search for part of the word or term, e.g., I may...
If you're using Excel 365, FILTER works well for this. For example, if your list is in A2:A100 and your search term is in D1, try:
=FILTER(A2:A100,ISNUMBER(SEARCH(D1,A2:A100)),"No matches found")
This will return every entry containing the text in D1, so searching for Asset would return Asset Management, Asset Tracking, etc. SEARCH is case-insensitive, which is usually helpful for this kind of search.