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

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.

Advanced Excel Formulas book (840 pages and more than 150 Excel functions)

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[tonyvillarreal]

FINALLY!!! This is the IF function (partial match) I've been wondering about and looking for about a year! THANK YOU!

[MarkBeckett-gqlp]

It's unreal how MS Excel has not created a simple" If (Contains function. Your tutorial really helped me through hours of figuring it out.

[Miramu]

Thank you this is really helpful. Your way of explaining and teaching makes it easy!

[taikeh]

Thank you for this video. Very clear and detailed. Very useful and time saving video. Again, thank you for taking the time to post this video.

[akashamale]

Thank you so much. You really saved my time. I was looking for something like this. It's so useful for sorting from a large data.

[humerahnaushadkhan]

Happy that yours was the first video that came up in my search. Liked they way you Zoomed in while typing the formula. Really thoughtful. Thank you so much.

[princess_k]

Thank you!! Your video helped me after 8 hours on this assignment.

[bowiecreative]

Great video. Do you have an example where if you have a text list that you want to add a specific value in a cell next the text if it is visible. For example everywhere I have the category “apples” I want to assign it the code 123 or if “oranges” is visible in a cell assign it “456”?

[mohideenthassim]

Wow! Alan, this is a great tip, many thanks for sharing a always.
Best regards
Mohideen

[vanityj]

Ahhhh!!! It worked for me 🎉🎉🎉 Just wanted to say Thank you so much for taking your time to teach. This video helped me immensely. Liked and subscribed ❤❤❤❤

[davidhartley]

Perfect! Exactly what i was looking for!!

[CMG]

That helped a lot, thanks - super glad you added the OR Function in the last part.

[richardvaldez]

Thank you!!! This was very helpful and well explained. I appreciate it.

[janturla]

Exactly what I was looking for!!! Thanks so much!

[andyg.]

THANK YOU!! This is exactly what I was looking for. Not sure how I found it, but cheers to you sir.

[ukwonderboy]

Thank you so much for this video, straight to the point and explained so easily!

[gospelmoto]

Wow! that was very clear. I learned something new today. I should have stumbled on this earlier. Thanks!

[howyadoing]

Great tutorial. You have the gift of teaching!

[safiyam]

Thank you! Have been looking for this! :)

[jyotisanjay]

Was struggling doing mannual changes everytime.. this saves a lot of time... thanks a lot