Excel IF Function: If Cell Contains Specific Text - Partial Match IF Formula

Share this & earn $10
Computergaga
Published at : 20 Oct 2021
401389 views
2151
106

In this video we use the IF function of Excel to test if a cell contains specific text.

Usually with the IF function you test a cell for a complete match, but in this example we need a partial match on text.

We then extend the scenario to handle a problem and then test for two different specific text strings.

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Microsoft ExcelIF FunctionIF Formula

Special Guest Purge - We Say Things 119

Special Guest Purge - We Say Things 119

Andy Mineo - Formerly Known

Andy Mineo - Formerly Known

GAMEBOARD Challenge But EVERYTHING Is DARES…

GAMEBOARD Challenge But EVERYTHING Is DARES…

GTA 5 - How To FIX "Error" You Are Attempting to Access GTA ONLINE Server with an Altered version"

GTA 5 - How To FIX "Error" You Are Attempting to Access GTA ONLINE Server with an Altered version"

AD INFINITUM - Unstoppable (Official Video) | Napalm Records

AD INFINITUM - Unstoppable (Official Video) | Napalm Records

Sharp AQUOS 8K VM2020 Video : "DIVERSE”

Sharp AQUOS 8K VM2020 Video : "DIVERSE”

Sci-Fi Short Film: "CYBOLICA" | DUST

Sci-Fi Short Film: "CYBOLICA" | DUST

How Black Widow Should Have Ended

How Black Widow Should Have Ended

Jesse Watters: This is only the beginning

Jesse Watters: This is only the beginning

♍️Virgo, YOU MIGHT WANT TO SIT DOWN FOR THIS ONE (IT’S GOOD) ❤️ November 2021

♍️Virgo, YOU MIGHT WANT TO SIT DOWN FOR THIS ONE (IT’S GOOD) ❤️ November 2021

Fugitive who spent years on the run explains why it can be hard to find people

Fugitive who spent years on the run explains why it can be hard to find people

Kayla Nicole - Recuperate (Lyrics)

Kayla Nicole - Recuperate (Lyrics)

A Body Free of the Tyranny of the Separate Self

A Body Free of the Tyranny of the Separate Self

Groove Coaster - Spring to Mind

Groove Coaster - Spring to Mind

Morrison government 'strongly committed' to ensuring online safety

Morrison government 'strongly committed' to ensuring online safety

Valkyrae Starts Tearing Up While Mentioning Sykkuno On First Stream Back

Valkyrae Starts Tearing Up While Mentioning Sykkuno On First Stream Back

“At The Beginning” from the 1997 ANASTASIA film | ANASTASIA The Musical

“At The Beginning” from the 1997 ANASTASIA film | ANASTASIA The Musical

Weird and Freaky Stuff Caught on Camera

Weird and Freaky Stuff Caught on Camera

TO BE CONTINUED COMPILATION

TO BE CONTINUED COMPILATION

The Dangers of Flash Flooding | IMR

The Dangers of Flash Flooding | IMR

Once Upon the Cross

Once Upon the Cross

How to use your Apple Watch | Apple Support

How to use your Apple Watch | Apple Support

Everlast - What it's Like (Music Video)

Everlast - What it's Like (Music Video)

LOSE 10 lbs Permanently in 5 Weeks, 5 Must Do Steps

LOSE 10 lbs Permanently in 5 Weeks, 5 Must Do Steps

Avoid and Prevent: Learn English with Simple English Videos

Avoid and Prevent: Learn English with Simple English Videos

GNAI - INTERNATIONAL (Official Music Video)

GNAI - INTERNATIONAL (Official Music Video)

Way of Thinking | Ibiza Sonica Beach Party | by  @EPHIMERA Tulum ​

Way of Thinking | Ibiza Sonica Beach Party | by @EPHIMERA Tulum ​

I BOUGHT COTTON UNDIES FOR YOU

I BOUGHT COTTON UNDIES FOR YOU

Game Theory: The Dark Lore of Brawl Stars (ft KairosTime)

Game Theory: The Dark Lore of Brawl Stars (ft KairosTime)

The Advantage - Dunsin Oyekan

The Advantage - Dunsin Oyekan

Sacrofiz & MonoPoly - Diverse

Sacrofiz & MonoPoly - Diverse

بث قراند : سيرفر فور لايف بطوله ملك المهجوره

بث قراند : سيرفر فور لايف بطوله ملك المهجوره

Top 5 Maison Margiela Fragrances | My Favorite Maison Margiela Fragrances, What Are Your Favorites?

Top 5 Maison Margiela Fragrances | My Favorite Maison Margiela Fragrances, What Are Your Favorites?

Guided Meditation: Acceptance Of The Present Moment

Guided Meditation: Acceptance Of The Present Moment

my parents think i am the devil

my parents think i am the devil

Built Up & Established - Kevin Zadai

Built Up & Established - Kevin Zadai

Anatomy of the Skin [Epidermis, Dermis, Hypodermis]

Anatomy of the Skin [Epidermis, Dermis, Hypodermis]

RAPIDLY meaning with examples in sentences

RAPIDLY meaning with examples in sentences

LABORIOUS

LABORIOUS

Miguel Becomes a Beast - Cobra Kai

Miguel Becomes a Beast - Cobra Kai

"오징어게임 remix" JJ x Solar l JJ choreography

"오징어게임 remix" JJ x Solar l JJ choreography

Initial D - All Around

Initial D - All Around

Galaxy S21 Durability Drop Test! FINALLY More Durable?

Galaxy S21 Durability Drop Test! FINALLY More Durable?

MUMMY PAPA 3 | Jokes | cs toons | Desi Comedy Video | School Classroom Jokes | paagal ladka

MUMMY PAPA 3 | Jokes | cs toons | Desi Comedy Video | School Classroom Jokes | paagal ladka

UFC Records: Fastest Finishes in History

UFC Records: Fastest Finishes in History

Francesca Battistelli - Strangely Dim (Official Lyric Video)

Francesca Battistelli - Strangely Dim (Official Lyric Video)

Diana and the Magic Flower. Learn to understand your desires and value friendship | Moral stories

Diana and the Magic Flower. Learn to understand your desires and value friendship | Moral stories

WEIGHT LOSS - Indian Weight Loss Diet

WEIGHT LOSS - Indian Weight Loss Diet

The Joy of Living Within Your Means

The Joy of Living Within Your Means