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

Share this & earn $10
Leila Gharani
Published at : 29 Nov 2020
289578 views
8701
94

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
XelplusVisExcel TutorialsLeila Gharani

The Rolling Stones - Paint It, Black (Official Lyric Video)

The Rolling Stones - Paint It, Black (Official Lyric Video)

Evil Geniuses Of The Animal Kingdom

Evil Geniuses Of The Animal Kingdom

Halloween Shopping in January?? || Lesbian Couple

Halloween Shopping in January?? || Lesbian Couple

The Glorious Sons - An Unplugged Evening Live at Longboat Hall

The Glorious Sons - An Unplugged Evening Live at Longboat Hall

Less Than Perfect S03e03

Less Than Perfect S03e03

SOME QUESTIONS TO EACH OTHER I SUDHIR I ROSHNI SHRESTHA

SOME QUESTIONS TO EACH OTHER I SUDHIR I ROSHNI SHRESTHA

Glass vs. Cheap Plastic | The REAL test of durability! Ft. #MiA3

Glass vs. Cheap Plastic | The REAL test of durability! Ft. #MiA3

ALL PROFIT FROM BUYDANGER (2 MONTHS) | Growtopia

ALL PROFIT FROM BUYDANGER (2 MONTHS) | Growtopia

Little question (desc)

Little question (desc)

Approved Kiss | On The Wings Of Love

Approved Kiss | On The Wings Of Love

HBO 2019 "Just The Start" Trailer (HD) Watchmen, Big Little Lies, Euphoria

HBO 2019 "Just The Start" Trailer (HD) Watchmen, Big Little Lies, Euphoria

Subtract using the column method, exchanging across more than one place value

Subtract using the column method, exchanging across more than one place value

KOKANDO PILLS - Japan pills | Slimming Pills | Review | Marky Nurse Vlogs

KOKANDO PILLS - Japan pills | Slimming Pills | Review | Marky Nurse Vlogs

REVIEWING A NASTY 1 STAR HOTEL IN HOLLYWOOD *GROSS*

REVIEWING A NASTY 1 STAR HOTEL IN HOLLYWOOD *GROSS*

How to Make a Traditional Paper Star so easy!

How to Make a Traditional Paper Star so easy!

BB MAK, BACK HERE

BB MAK, BACK HERE

Husbands' weekend morning routine (two nice bois)

Husbands' weekend morning routine (two nice bois)

What's The Difference? - Carbon Fibre VS Aluminium Wheels

What's The Difference? - Carbon Fibre VS Aluminium Wheels

ATB - Don't Stop (Official Video HD)

ATB - Don't Stop (Official Video HD)

Prometheus Burning - Significantly Altered

Prometheus Burning - Significantly Altered

BLACKPINK ' HYLT x Pretty Savage x Ice Cream x Lovesick Girls' (Award Show Performance Concept)

BLACKPINK ' HYLT x Pretty Savage x Ice Cream x Lovesick Girls' (Award Show Performance Concept)

Belarus: Revolution or Regression?

Belarus: Revolution or Regression?

Best Gerber Multi Tool - The Center Drive Plus - They Got It Right!

Best Gerber Multi Tool - The Center Drive Plus - They Got It Right!

How To! - Create a Customized Windows 7 With Integrated Updates Using RT Se7en Lite

How To! - Create a Customized Windows 7 With Integrated Updates Using RT Se7en Lite

[Vietsub] Criminal - Britney Spears

[Vietsub] Criminal - Britney Spears

Coldplay - Trouble In Town (Official Video)

Coldplay - Trouble In Town (Official Video)

Don Ross - My Previous Life

Don Ross - My Previous Life

BEST GLAMOROUS DRESS COMPILATION

BEST GLAMOROUS DRESS COMPILATION

Von. - Oohmygod

Von. - Oohmygod

xQc Reacts to Uncommon Clips 1 (Streamers Out of Context)

xQc Reacts to Uncommon Clips 1 (Streamers Out of Context)

8 Qualities of Truly Authentic People

8 Qualities of Truly Authentic People

The 2nd | Official Trailer | Voltage Pictures

The 2nd | Official Trailer | Voltage Pictures

How To Name Acids - The Fast & Easy Way!

How To Name Acids - The Fast & Easy Way!

Woman whispers for help in a chilling 911 call

Woman whispers for help in a chilling 911 call

Jim Rohn: TIME IS VALUABLE - Motivational Speech

Jim Rohn: TIME IS VALUABLE - Motivational Speech

THE CASE FOR THE BREAKOUT as RIPPLE XRP PRICE CHART Battles Retrace Level with Bitcoin All Time High

THE CASE FOR THE BREAKOUT as RIPPLE XRP PRICE CHART Battles Retrace Level with Bitcoin All Time High

Two English mistakes with the word "BOTH"

Two English mistakes with the word "BOTH"

The Pleased - We are the Doctor

The Pleased - We are the Doctor

Curren$y feat. Prodigy - The Type (Pd. by Alchemist) 2011

Curren$y feat. Prodigy - The Type (Pd. by Alchemist) 2011

The Cobra Kai Cast Play "Who's Most Likely To"

The Cobra Kai Cast Play "Who's Most Likely To"

Beauty Products I Brought on Vacation

Beauty Products I Brought on Vacation

SIDEMEN $50,000 RACE ACROSS THE UK

SIDEMEN $50,000 RACE ACROSS THE UK

Awesome Rainbow Cake Decorating Tutorials | Easy Colorful Cake Hacks Compilation | Extreme Cake

Awesome Rainbow Cake Decorating Tutorials | Easy Colorful Cake Hacks Compilation | Extreme Cake

History - Might Just Die (blindfolded dance practice) DVhd

History - Might Just Die (blindfolded dance practice) DVhd

Forevermore Flute or Violin Sheet Music Backing Track Play Along Side A Band

Forevermore Flute or Violin Sheet Music Backing Track Play Along Side A Band

LEARN UNITY - The Most BASIC TUTORIAL I'll Ever Make

LEARN UNITY - The Most BASIC TUTORIAL I'll Ever Make

70th Republic day 2019 was celebrated with gaiety and fervour in the Anantnag district.,

70th Republic day 2019 was celebrated with gaiety and fervour in the Anantnag district.,

If you guess the number, you will be the thumbnail and also get pinned

If you guess the number, you will be the thumbnail and also get pinned

DISAPPOINTING SMII7Y FOR 17 MINUTES STRAIGHT

DISAPPOINTING SMII7Y FOR 17 MINUTES STRAIGHT