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

Share this & earn $10
Computergaga
Published at : 26 Sep 2021
386875 views
2080
103

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

Gebrochenen Laptop zu einem Desktop PC umbauen-Ruben Orfeo

Gebrochenen Laptop zu einem Desktop PC umbauen-Ruben Orfeo

Gajar Ka Halwa by Food Plan | Carrot Halwa authentic Recipe | How to make gajar ka halwa | food plan

Gajar Ka Halwa by Food Plan | Carrot Halwa authentic Recipe | How to make gajar ka halwa | food plan

Coming This May | Disney+

Coming This May | Disney+

Human perception towards God || by divulge to you || D2U

Human perception towards God || by divulge to you || D2U

Elite Division Custom Tactics

Elite Division Custom Tactics

TBC Classic World First T5 SSC + TK by [Progress] in 1hr 45mis

TBC Classic World First T5 SSC + TK by [Progress] in 1hr 45mis

Frida | 'Dancing Around An Issue' (HD) - Salma Hayek, Ashley Judd | MIRAMAX

Frida | 'Dancing Around An Issue' (HD) - Salma Hayek, Ashley Judd | MIRAMAX

Sleepy Hallow - Bad Luck Instrumental (Remake)

Sleepy Hallow - Bad Luck Instrumental (Remake)

FNF TikTok Compilation 68 | Friday Night Funkin’ mod The Best TikTok Compilation

FNF TikTok Compilation 68 | Friday Night Funkin’ mod The Best TikTok Compilation

Phil Wickham - House Of The Lord (Official Lyric Video)

Phil Wickham - House Of The Lord (Official Lyric Video)

Mr. No Problem by The d.e.p

Mr. No Problem by The d.e.p

✪ IELTS Speaking Part 2, 3 (Band 7.0 - 8.0): Topic 16 - Sporting event

✪ IELTS Speaking Part 2, 3 (Band 7.0 - 8.0): Topic 16 - Sporting event

Maintaining Artistic Quality and Efficiency with the Oven | Proof Bread

Maintaining Artistic Quality and Efficiency with the Oven | Proof Bread

I Hired an ARMY to Hunt my Brother!

I Hired an ARMY to Hunt my Brother!

JUNGKOOK so happy to announce that they are having LIVE CONCERT IN LA!!! YAYAYYYYYYY

JUNGKOOK so happy to announce that they are having LIVE CONCERT IN LA!!! YAYAYYYYYYY

Khalid - Better (Official Video)

Khalid - Better (Official Video)

DJ Khaled - Take It To The Head (Explicit) [Official Video]

DJ Khaled - Take It To The Head (Explicit) [Official Video]

Why There's Almost Certainly No Such Thing As Free Will

Why There's Almost Certainly No Such Thing As Free Will

Δημήτρης Μπάσης - Κάθε Μέρα (από την τηλεοπτική σειρά "Σασμός") - Official Lyric Video

Δημήτρης Μπάσης - Κάθε Μέρα (από την τηλεοπτική σειρά "Σασμός") - Official Lyric Video

Private Pyle - Jelly Doughnut (HD)

Private Pyle - Jelly Doughnut (HD)

2021 English Gospel Song With Lyrics | "The Incarnate God Is Most Lovable"

2021 English Gospel Song With Lyrics | "The Incarnate God Is Most Lovable"

6 NEW features in Microsoft Teams 2021 | Whiteboard updates, Reply to Specific Chat message, & more

6 NEW features in Microsoft Teams 2021 | Whiteboard updates, Reply to Specific Chat message, & more

College Admissions 101: What Do Colleges Look For? | The Princeton Review

College Admissions 101: What Do Colleges Look For? | The Princeton Review

Holiday Shopping at J.Crew Factory Store | Men, Women, Kids Clothing, Accessories, Sweaters and More

Holiday Shopping at J.Crew Factory Store | Men, Women, Kids Clothing, Accessories, Sweaters and More

DEKU RAP SONG | "Prove" | RUSTAGE ft. Ozzaworld [My Hero Academia]

DEKU RAP SONG | "Prove" | RUSTAGE ft. Ozzaworld [My Hero Academia]

Man attacked by several people in Hollywood

Man attacked by several people in Hollywood

2003 BMW 525i 5MT Sport Package: Regular Car Reviews

2003 BMW 525i 5MT Sport Package: Regular Car Reviews

Saweetie x London On Da Track - Up Now (feat. G-Eazy and Rich The Kid) [Official Music Video]

Saweetie x London On Da Track - Up Now (feat. G-Eazy and Rich The Kid) [Official Music Video]

A Dangerous Method Official Trailer (2011) HD

A Dangerous Method Official Trailer (2011) HD

Cyber Security - or How to Protect Your Enterprise From Child Sexual Abuse Material 🛑

Cyber Security - or How to Protect Your Enterprise From Child Sexual Abuse Material 🛑

Study Music Alpha Waves: Relaxing Studying Music, Brain Power, Focus Concentration Music, ☯161

Study Music Alpha Waves: Relaxing Studying Music, Brain Power, Focus Concentration Music, ☯161

my skincare routine that involves NO turmeric or tomatoes...

my skincare routine that involves NO turmeric or tomatoes...

Fast and Flexible Interiors Processing

Fast and Flexible Interiors Processing

fiery tears in a monotonous world

fiery tears in a monotonous world

10 BEST EVERYDAY FALL PERFUMES 2021

10 BEST EVERYDAY FALL PERFUMES 2021

BACKYARD FLOWER SURPRiSE!!  Adley helps water the garden, petal pets, blume babies (mystery package)

BACKYARD FLOWER SURPRiSE!! Adley helps water the garden, petal pets, blume babies (mystery package)

10 Designer Fragrances That Are WORTH EVERY PENNY - Pick These Up

10 Designer Fragrances That Are WORTH EVERY PENNY - Pick These Up

The Big Numbers Song

The Big Numbers Song

WTF JUNGLE IN 2021?? Level 1 Jungler Huskar 6Min Armlet & Solo Roshan EPIC Armlet Toggle Dota 2

WTF JUNGLE IN 2021?? Level 1 Jungler Huskar 6Min Armlet & Solo Roshan EPIC Armlet Toggle Dota 2

Solomun Louie Austen - Hoping

Solomun Louie Austen - Hoping

Natalie Taylor - Surrender (Lyrics)

Natalie Taylor - Surrender (Lyrics)

Bearson - It's Not This (feat. Lemaitre & Josh Pan)

Bearson - It's Not This (feat. Lemaitre & Josh Pan)

Five For Fighting - Chances lyrics

Five For Fighting - Chances lyrics

OVERWATCH MAKES NO SENSE

OVERWATCH MAKES NO SENSE

Nelly - Dilemma (Official Music Video) ft. Kelly Rowland

Nelly - Dilemma (Official Music Video) ft. Kelly Rowland

Sonicaid - Music to Enhance Concentration [HQ]

Sonicaid - Music to Enhance Concentration [HQ]

What's the difference between accuracy and precision? - Matt Anticole

What's the difference between accuracy and precision? - Matt Anticole

Use of given the fact that, given that & in view of in English | English by spoken english sir.

Use of given the fact that, given that & in view of in English | English by spoken english sir.

How to sit up straight easily using the right muscles

How to sit up straight easily using the right muscles