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
-
1:57:34
vivafrei
4 hours agoCanada: Fentanyl Capital of the World w/ Sam Cooper! Pierre Poilievre Listening to Viva w/ Pleb!
68.2K35 -
LIVE
Nerdrotic
3 hours ago $5.15 earnedPost-Apocalyptic Woke Hollywood, MineCRAP, CinemaCONNED - Friday Night Tights 348, Chris Gore & Rags
4,544 watching -
50:21
Michael Franzese
2 hours agoThe Rise and Fall of Joe Colombo: From Head of the Family to Public Enemy
21.1K3 -
8:21
Talk Nerdy Sports - The Ultimate Sports Betting Podcast
1 hour ago4/4/25 - AI Madness & Friday Fire
10.7K -
DVR
Dr Disrespect
7 hours ago🔴LIVE - DR DISRESPECT - WARZONE - VERDANSK SOLOS
141K10 -
LIVE
FusedAegisTV
4 hours agoRumble Smackdown! #001 Street Fighter 6 $500 Online Tournament
123 watching -
LIVE
Major League Fishing
3 days agoLIVE! - MLF Bass Pro Tour: REDCREST - Day 2
175 watching -
1:08:28
Twins Pod
10 hours agoConservative Latina FIRECRACKER Running For CONGRESS! | Twins Pod - Episode 59 - Valentina Gomez
40.6K12 -
1:07:56
Jeff Ahern
3 hours ago $1.00 earnedFriday Freak out with Jeff Ahern (1pm Pacific)
30.7K -
2:11:58
The Quartering
6 hours agoTrump's Job Market EXPLODES, Bill Burr Runs, Matt Walsh Triggers , Leftist Attacks My Company
179K97