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

Share this & earn $10
Computergaga
Published at : 14 Nov 2021
416540 views
2226
112

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

How to Classify Accounts | Real, Personal & Nominal |Classification of Accounts|Letstute Accountancy

How to Classify Accounts | Real, Personal & Nominal |Classification of Accounts|Letstute Accountancy

Adverts That LIE To Us

Adverts That LIE To Us

Carnage - Learn How To Watch ft. Mac Miller & MadeinTYO (Directed by Cole Bennett)

Carnage - Learn How To Watch ft. Mac Miller & MadeinTYO (Directed by Cole Bennett)

Natasha Kay - Upgrade - Official Music Video

Natasha Kay - Upgrade - Official Music Video

I Bought the Weirdest Keyboard Ever

I Bought the Weirdest Keyboard Ever

Grizzly Bear - Yet Again (from 'Shields', album out September 17/18)

Grizzly Bear - Yet Again (from 'Shields', album out September 17/18)

100 People Tell Us How Much Money They Make | Keep it 100 | Cut

100 People Tell Us How Much Money They Make | Keep it 100 | Cut

How To Master Any Skill (Become Top 1%)

How To Master Any Skill (Become Top 1%)

Important Concepts for Selecting Manual Translation Stages

Important Concepts for Selecting Manual Translation Stages

ΔΗΜΟΤΙΚΟ VS ΓΥΜΝΑΣΙΟ - Rap Battle

ΔΗΜΟΤΙΚΟ VS ΓΥΜΝΑΣΙΟ - Rap Battle

Word of the Week 2: Utilize

Word of the Week 2: Utilize

WATCH THIS To Manifest Anything YOU WANT In Life! (Joe Dispenza, Bob Proctor, Wayne Dyer)

WATCH THIS To Manifest Anything YOU WANT In Life! (Joe Dispenza, Bob Proctor, Wayne Dyer)

47 EPISCIA VARIETIES /FLAME VIOLET

47 EPISCIA VARIETIES /FLAME VIOLET

Take off the Old Uniform, Put on New: Ephesians 4:25–29, Part 1

Take off the Old Uniform, Put on New: Ephesians 4:25–29, Part 1

Arm Wrestling Training | November 2021

Arm Wrestling Training | November 2021

11 tháng 5 ngày tập 28 | Đăng giấu bí mật kinh hoàng?

11 tháng 5 ngày tập 28 | Đăng giấu bí mật kinh hoàng?

Scars to your beautiful - Alessia Cara (Lyrics)

Scars to your beautiful - Alessia Cara (Lyrics)

How to Beat the MASKED KILLER in "THERE'S SOMEONE INSIDE YOUR HOUSE" (2021)

How to Beat the MASKED KILLER in "THERE'S SOMEONE INSIDE YOUR HOUSE" (2021)

The Cure - Close To Me (Official Video)

The Cure - Close To Me (Official Video)

AIB : Honest Engineering Campus Placements | Part 01

AIB : Honest Engineering Campus Placements | Part 01

STORY TIME | So Much by Trish Cooke | Children's Stories Read Aloud for Kids by Kids!

STORY TIME | So Much by Trish Cooke | Children's Stories Read Aloud for Kids by Kids!

way back

way back

Moments You Wouldn’t Believe if They Weren’t Recorded

Moments You Wouldn’t Believe if They Weren’t Recorded

Nightbirde – It’s Okay (Lyrics)

Nightbirde – It’s Okay (Lyrics)

My Savior My God By Aaron Shust

My Savior My God By Aaron Shust

This Anonymous Man Claims He's A Time Traveler & Revealed That Something Big Is About To Happen

This Anonymous Man Claims He's A Time Traveler & Revealed That Something Big Is About To Happen

Motor Launches play a vital part in the war at sea (1942)

Motor Launches play a vital part in the war at sea (1942)

Exact PipeCut 280/360/460 Pro Series instruction video

Exact PipeCut 280/360/460 Pro Series instruction video

(sub)Get Rid of FLABBY ARMS in ONE WEEK at home//Result: -3cm

(sub)Get Rid of FLABBY ARMS in ONE WEEK at home//Result: -3cm

Nura - Fair | Machiavelli Sessions @ KOSMOS Chemnitz

Nura - Fair | Machiavelli Sessions @ KOSMOS Chemnitz

Robotically Assisted Knee Replacement - Ask the Doctor Series

Robotically Assisted Knee Replacement - Ask the Doctor Series

How to submit your work to an illustration agency

How to submit your work to an illustration agency

Yungen ft. One Acen - Pricey [Music Video] | GRM Daily

Yungen ft. One Acen - Pricey [Music Video] | GRM Daily

Brantridge Lane to Grouse Road

Brantridge Lane to Grouse Road

Breaking News | Finally

Breaking News | Finally

Ben l'Oncle Soul « I've got you under my skin » (Frank Sinatra cover)

Ben l'Oncle Soul « I've got you under my skin » (Frank Sinatra cover)

DVD Completo Vineyard - Vem Esta É A Hora (Ao Vivo)

DVD Completo Vineyard - Vem Esta É A Hora (Ao Vivo)

Have an Excellent Day!

Have an Excellent Day!

[1 Hour] Lim Chang Jung - 되풀이 (Repeatedly) OST Penthouse 2 Part 1

[1 Hour] Lim Chang Jung - 되풀이 (Repeatedly) OST Penthouse 2 Part 1

5 tips to reduce food waste

5 tips to reduce food waste

How to Make a SCANIA V8 More Economical & Powerful!

How to Make a SCANIA V8 More Economical & Powerful!

Solo Hiking in the Desert | geology and calmness

Solo Hiking in the Desert | geology and calmness

Soul Fusion | Yu-Gi-Oh! Progression Series #69

Soul Fusion | Yu-Gi-Oh! Progression Series #69

Katy Perry - Hot N Cold (Lyrics)

Katy Perry - Hot N Cold (Lyrics)

KLOË - Grip (live at The Quay)

KLOË - Grip (live at The Quay)

23 Advertising Techniques Used to Create Powerful and Persuasive Ads

23 Advertising Techniques Used to Create Powerful and Persuasive Ads

Sewing Tips and Tricks - Sewing Tips & Techniques From Only Elastic | DIY 85

Sewing Tips and Tricks - Sewing Tips & Techniques From Only Elastic | DIY 85

Biden Assures Macron That France Is 'Incredibly Valuable' U.S. Ally

Biden Assures Macron That France Is 'Incredibly Valuable' U.S. Ally

CrossFit Games SemiFinals - Day 1, - Annie Thorisdottir, Frederik Ægidius and BK Gudmundsson

CrossFit Games SemiFinals - Day 1, - Annie Thorisdottir, Frederik Ægidius and BK Gudmundsson