Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Check if a cell contains specific text with IF, ISNUMBER and SEARCH, since wildcards don't work in IF. 📥 Download the practice workbook (company codes plus every partial match formula): https://www.xelplus.com/if-function-w... 🎓 Fill the gaps in your Excel skills with Excel Essentials for the Real World. 500,000+ enrolled in our courses: https://www.xelplus.com/course/learn-... Wildcards like AT work in SUMIFS and COUNTIFS, but not in the IF logical test. SEARCH returns the position of the text, or an error if the text isn't there. ISNUMBER turns that into TRUE or FALSE, which IF can use. SEARCH ignores case. Use FIND when the case has to match. Then add OR to check for more than one text string, for example AT or DE returns Europe. The same approach works in SUMPRODUCT. Good to know: COUNTIF accepts wildcards, so =IF(COUNTIF(A5,"*AT*"),"AT","") also works in every Excel version. In Microsoft 365, REGEXTEST checks several strings in one pattern: =IF(REGEXTEST(A5,"AT|DE"),"Europe",""). 00:00 IF cell contains specific text: can you use wildcards? 00:35 Why wildcards don't work in the IF function 02:07 SEARCH function: find text inside a cell 03:04 FIND function for a case-sensitive search 03:51 ISNUMBER turns SEARCH into TRUE or FALSE 04:21 IF with ISNUMBER and SEARCH 04:56 IF cell contains one of several words (OR) 🎬 Partial match in SUMIFS:    • How to Use SUMIFS with Partial Match and W...   🎬 How the IF function works:    • Excel IF Formula: Simple to Advanced (mult...   ➡️ Join this channel to get access to perks:    / @leilagharani   ✉️ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter 🚩 Connect with us: Instagram:   / lgharani   LinkedIn:   / leilagharani   #excel #exceltips #excelformulas