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

Share this & earn $10
Computergaga
Published at : 11 Oct 2021
395669 views
2128
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

And They're Off Trailer (2011) HD

And They're Off Trailer (2011) HD

Brand New Lyrics - Ben Rector

Brand New Lyrics - Ben Rector

Government Regulation: Crash Course Government and Politics #47

Government Regulation: Crash Course Government and Politics #47

MOM4ETO x DIM4OU x EMIL TRF - AFKORS ( OFFICIAL VIDEO ) prod by VITAMIN TZE

MOM4ETO x DIM4OU x EMIL TRF - AFKORS ( OFFICIAL VIDEO ) prod by VITAMIN TZE

WARZONE: EVERYTHING You NEED TO KNOW About The OPERATION: FLASHBACK Event...

WARZONE: EVERYTHING You NEED TO KNOW About The OPERATION: FLASHBACK Event...

Maroon 5 - Misery (Official Music Video)

Maroon 5 - Misery (Official Music Video)

Abraham Hicks - Relationships - There are lots of partners, you are dictating each of them - Z.Z

Abraham Hicks - Relationships - There are lots of partners, you are dictating each of them - Z.Z

All Kinds

All Kinds

Yolte - Fantastic (Official Audio Video)

Yolte - Fantastic (Official Audio Video)

ADVANCED English Grammar: How to use SUGGEST & RECOMMEND

ADVANCED English Grammar: How to use SUGGEST & RECOMMEND

THIS QUIZ IMPROVE YOUR IQ LEVEL : FIND ANYONE BUT NOT NAYMAR JR ?? FOOTBALL QUIZ  HARD LEVEL 1,2,3

THIS QUIZ IMPROVE YOUR IQ LEVEL : FIND ANYONE BUT NOT NAYMAR JR ?? FOOTBALL QUIZ HARD LEVEL 1,2,3

Bobby East feat. Jorzi - All Over(Official Music Video)

Bobby East feat. Jorzi - All Over(Official Music Video)

RC71: Health in prisons - addressing the public health gap to ensure that no one is left behind

RC71: Health in prisons - addressing the public health gap to ensure that no one is left behind

KALEO "Automobile" [Official Audio]

KALEO "Automobile" [Official Audio]

Wiz Khalifa - DayToday - Gettin ready for New York and Vegas

Wiz Khalifa - DayToday - Gettin ready for New York and Vegas

Shane Dawson's Body Language During His Comeback is Revealing

Shane Dawson's Body Language During His Comeback is Revealing

Unmarried Couple | Shamim Hasan Sarkar | Tasnuva Tisha | Tanzim Hasan Anik | Bangla New Natok 2021

Unmarried Couple | Shamim Hasan Sarkar | Tasnuva Tisha | Tanzim Hasan Anik | Bangla New Natok 2021

1.1.3 The role of business enterprise GCSE Business

1.1.3 The role of business enterprise GCSE Business

Grupo Niche - Miserable (Cover Audio Video)

Grupo Niche - Miserable (Cover Audio Video)

Good & Plenty Official Lyric Video

Good & Plenty Official Lyric Video

Want to RETIRE before 30? WATCH THIS!

Want to RETIRE before 30? WATCH THIS!

Using besides, except and apart from in English

Using besides, except and apart from in English

London, England: Harrods Department Store

London, England: Harrods Department Store

Present Perfect Unspecified Time

Present Perfect Unspecified Time

Gratis sjakkurs for seniorsentre

Gratis sjakkurs for seniorsentre

Locomondo - 80s - Official Video Clip

Locomondo - 80s - Official Video Clip

H.E.R.  Every kind of way lyrics

H.E.R. Every kind of way lyrics

Mr. Joe Camaro was Filled with Gasoline in Gas Tank of Lamborghini Aventador 13+

Mr. Joe Camaro was Filled with Gasoline in Gas Tank of Lamborghini Aventador 13+

🙁 SUFFERING FROM BAD LUCK in Pokémon Go

🙁 SUFFERING FROM BAD LUCK in Pokémon Go

The Grievance Process

The Grievance Process

Affirmations for Health, Wealth, Happiness, Abundance "I AM" (21 days to a New You!)

Affirmations for Health, Wealth, Happiness, Abundance "I AM" (21 days to a New You!)

Amazing Woodworking Ideas // How To Build A Unique And Beautiful Outdoor Coffee Table - DIY

Amazing Woodworking Ideas // How To Build A Unique And Beautiful Outdoor Coffee Table - DIY

How to pronounce "there" they're" and "their"  #shorts

How to pronounce "there" they're" and "their" #shorts

LOUD - Thoughts

LOUD - Thoughts

ERA - Ameno

ERA - Ameno

Madeon - Pop Culture (live mashup)

Madeon - Pop Culture (live mashup)

10. Rupert Holmes - Escape (The Piña Colada Song)

10. Rupert Holmes - Escape (The Piña Colada Song)

Preschool Learning Video with Lots of Fun Educational Toys!

Preschool Learning Video with Lots of Fun Educational Toys!

MAJOR GRAND FINAL! - NaVi vs G2 - PGL Major Stockholm 2021 - HIGHLIGHTS | CSGO

MAJOR GRAND FINAL! - NaVi vs G2 - PGL Major Stockholm 2021 - HIGHLIGHTS | CSGO

Before You Install Linux - STOP! Ask Yourself Some Questions First

Before You Install Linux - STOP! Ask Yourself Some Questions First

🔴 Sleep Music 24/7, Insomnia, Relaxing Music, Spa, Calm Music, Sleep Meditation, Study Music, Sleep

🔴 Sleep Music 24/7, Insomnia, Relaxing Music, Spa, Calm Music, Sleep Meditation, Study Music, Sleep

Pretty

Pretty

Jewish Misconception # 25 We Have A Tendency To Sin

Jewish Misconception # 25 We Have A Tendency To Sin

WATCH THIS AND YOU WILL NEVER HAVE A BAD DAY AGAIN

WATCH THIS AND YOU WILL NEVER HAVE A BAD DAY AGAIN

Wax Tailor Ft. M.Quaisse & A.S.M - Positively inclined (Official video)

Wax Tailor Ft. M.Quaisse & A.S.M - Positively inclined (Official video)

PATIENCE IS KEY - Best Motivational Speech 2020

PATIENCE IS KEY - Best Motivational Speech 2020

BANDO - Deals | Official Audio Release

BANDO - Deals | Official Audio Release

Με ξεφτιλίζει ο Δημήτρης! | What's in our bags | Black Velour

Με ξεφτιλίζει ο Δημήτρης! | What's in our bags | Black Velour

MATHS | Calculate Compound Interest | Annually, Half Yearly, Quarterly, Monthly

MATHS | Calculate Compound Interest | Annually, Half Yearly, Quarterly, Monthly