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
-
16:07
Ken LaCorte: Elephants in Rooms
11 hours agoWhy firefighting got political
3742 -
8:31
Rethinking the Dollar
15 hours agoBitcoin Secrets Nobody Talks About!
6924 -
2:36:47
DLDAfterDark
5 hours ago $0.35 earnedIs The Left Recruiting To KILL Conservatives? Hey Fascist, CATCH!
9051 -
22:53
Jasmin Laine
1 day agoParliament ERUPTS After "WORST Decision EVER!"—Carney Left SPEECHLESS by SHOCKING Report
29.7K73 -
11:50
Mrgunsngear
1 day ago $7.44 earnedSteiner MPS Enclosed Red Dot: Better Than The ACRO P2? 🔴
28.5K17 -
1:27:55
Sarah Westall
1 day agoSelecting World Leaders: Intelligence No Longer a Prerequisite w/ Martin Armstrong
38.2K21 -
2:03:07
Badlands Media
1 day agoDevolution Power Hour Ep. 393: Synthetic Reality, and the RICO Grande Strategy
65.2K24 -
11:23:18
GritsGG
12 hours agoQuad Win Streaks!🫡 Most Wins in WORLD! 3600+
77.3K10 -
41:16
MattMorseTV
7 hours ago $77.29 earned🔴Antifa is PREPARING for WAR.🔴
74.7K432 -
2:55:38
cosmicvandenim
15 hours agoCOSMIC VAN DENIM | Horror Game | STOREBOUND
27.1K3