Premium Only Content

Excel IF Function with PARTIAL Text Match (IF with Wildcards)
30 May 2019 Excel Advanced Formulas & Features
Learn how to combine Excel's IF function with wildcards for a partial text match. For example, you'd like to check IF a cell contains a specific word. If yes, then you'd like a specific result, otherwise you'd like another result.
We also take a look at checking the data against multiple partial match strings.
If you're familiar with the IF function, you know the logical test argument looks for an exact match. In case you'd like to look for a partial match in the IF formula (Excel IF function with text containing another word), you can't use an asterisk sign just like you would in the SUMIFS or COUNTIFS formulas. Instead you need to either use the SEARCH or the FIND functions. These will act as your wildcards.
You can apply the same approach to the SUMPRODUCT function.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/if-function-with-wildcard-partial-text-match/
LINKS to related videos: Partial match in SUMIFS function: https://youtu.be/2h90wU9jicI
Learn how IF function works: https://youtu.be/KkTaQ5OjAGc
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: 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!
#MsExcel #Excel #LeilaGharani
-
LIVE
Dr Disrespect
10 hours ago🔴LIVE - DR DISRESPECT - PUBG - 5 CHICKEN DINNERS CHALLENGE
3,916 watching -
LIVE
SynthTrax & DJ Cheezus Livestreams
11 hours agoFriday Night Synthwave 80s 90s Electronica and more DJ MIX Livestream THE GREAT EDO WARS OF 2067 Edition
352 watching -
LIVE
RalliedLIVE
1 hour ago $0.02 earnedWarzone Domination w/ Ral
232 watching -
1:10:17
Sarah Westall
3 hours agoWorld Leaders Increasingly Display Panic Behavior as Economic Change Accelerates w/ Andy Schectman
11.4K1 -
41:57
BonginoReport
5 hours agoProtecting Kids From WOKE Ideology in School (Ep. 35) - Nightly Scroll with Hayley Caronia -04/25/25
63.7K21 -
1:15:07
Kim Iversen
1 day agoThe Left Is Dead — What And Who Will Rise From the Ashes?
64.6K55 -
LIVE
Joker Effect
29 minutes agoYOU DON'T UNDERSTAND FREEDOM OF SPEECH IF THIS MAKES YOU MAD!
254 watching -
LIVE
SpartakusLIVE
3 hours agoFriday Night HYPE w/ #1 All-American Solo NUKE Hero
68 watching -
1:45:26
vivafrei
7 hours agoSantos Sentenced to 87 MONTHS! Corrupt Judges ARRESTED! Some Canada Stuff & MORE!
108K73 -
4:34:03
Nerdrotic
6 hours ago $17.38 earnedStar Wars GRAPED? Hollywood In Freefall, Silver Surfer is a MAN! | Friday Night Tights 351
68.6K18