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
-
8:13:09
Akademiks
15 hours agoIs It OVER for DRAKE?? Industry and Fans Turned on him? Cassie Tryna not get CHARGED w/ Diddy?
74.8K157 -
3:57:39
FusedAegisTV
12 hours agoMax Payne 3 (2012)... For Real Now | When Western Games Weren't Ghey #1 RUMBLE CREATOR HOUSE EDITION
27.8K12 -
1:21:37
Roseanne Barr
2 days ago $103.27 earnedKevin Sorbo saves America | The Roseanne Barr Podcast #49
142K449 -
38:57
The Why Files
1 day agoBackyard Time Machine: The Time Travel Mystery of Mike “Mad Man” Marcum
56.5K68 -
3:58:52
Due Dissidence
20 hours agoBronx Trump Rally SPECIAL REPORT, Chappelle SLAMS Israel, Greenwald OWNS Dershowitz
68.7K116 -
21:53
Breaking Points
21 hours ago5/26/24 AMA
28.1K11 -
2:58:31
SonnyFaz
13 hours agoSNEAKO X SONNY NEW YORK TAKEOVER!
51.1K38 -
2:13:04
vivafrei
22 hours agoEp. 212: Trump FBI Raid; Alex Jones' Lawyer Victory; Biden Ballot & MORE! Viva & Barnes
153K292 -
6:38:26
PudgeTV
16 hours agoBorderlands 2 From the Content Creator House | Fortnite w Frag | Happy Memorial Day Weekend
68.3K11 -
3:32:12
SNEAKO
18 hours agoNYC One Minute Podcast! (DAY 2)
157K125