How to do Partial Match with Filter Function in Excel? 🧑‍💻🔎 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. #Excel #exceltip