Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Unlock the secrets of using wildcards in Excel's IF function in this detailed tutorial. This video breaks down the challenges of integrating wildcards in logical tests and provides an effective alternative approach.

✨ Key Highlights:
▪️ Wildcards & IF Function: Explore why traditional wildcards don't work in IF functions and discover an alternative method.
▪️ Using SEARCH and ISNUMBER Functions: Learn to use the SEARCH and ISNUMBER functions as a wildcard substitute in IF formulas.
▪️ Case Sensitivity in Searches: Understand the difference between SEARCH (not case-sensitive) and FIND (case-sensitive) functions.
▪️ Practical Examples: See step-by-step demonstrations on how to identify specific text patterns within data.
▪️ OR Function for Multiple Conditions: Combine the OR function with SEARCH and ISNUMBER for more complex logical tests.

00:00 Excel Formula If Cell Contains Specific Text
00:35 IF Function with Wildcards
02:02 How to Use the SEARCH Function in Excel
03:51 How to Use ISNUMBER
04:16 IF Function with Wildcards
04:56 IF Function with Wildcards - Multiple Criteria

Learn how to combine Excel's IF function with wildcards for a partial text match. For example, you'd like to check IF a cell contains a specific word. If yes, then you'd like a specific result, otherwise you'd like another result.

We also take a look at checking the data against multiple partial match strings.
If you're familiar with the IF function, you know the logical test argument looks for an exact match. In case you'd like to look for a partial match in the IF formula (Excel IF function with text containing another word), you can't use an asterisk sign just like you would in the SUMIFS or COUNTIFS formulas. Instead you need to either use the SEARCH or the FIND functions. These will act as your wildcards.
You can apply the same approach to the SUMPRODUCT function.

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[jays]

I had to check 7, 000 entries of comments (long'ish text) from customers, we were interested in finding a particular word in the comments. Your tutorial here just saved me days of boring 'eye-balling' work, Wonderful! Thank you. BTW, I prefer your style of teaching than many others - it's always clear, no rambling and intuitive. Many thanks again.

[AnuroopBangalore]

I had to display list of values based on partial match of text in the previous column cells. This helped me resolve an issue which I was struggling for days. You are awesome. Thanks ! For anyone who is new in Excel, this channel is good info here.

[jdpalm]

Holy crap!!! That was way more informative than searching through stackoverflow!

[BrianMegilligan]

I appreciate that you take us through the steps of things that won't work and explain why. This makes it easy to follow and is useful for cases where those functions that don't work in this case might be useful for something else we encounter in the future. Thank you for your work on this!

[brianfields]

I find your explanations and applications to be the best. Even when I delve into some obscure situations you have answers that work. Thank you so much for your postings.

[francodoshe]

This is my online lecturer of all time...🙏

Be blessed teacher.

[wassouf]

You have saved my life in excel so many times. Thank you

[natraj]

Hey Leila have been following you regularly, your online classes made me look like a king before my colleagues at office, thanks a lot!

[MeliPatoco]

That awesome moment you come to see a Leila video because the title tells you this is going to be useful, and it is a formula that you use almost daily at your job. Feels amazing

[Titina]

Thank you Leila for these videos. Your explanations are so clear. 😊

[peteringvorsen]

Thanks Leila😊
Once again, you show a learning video that's easy to understand for everyone👍

[sZenji]

i was looking over 4 weeks for this formula in the internet and suddenly youtuve recomends me this video and you gave me the solution i finnaly needed thank you so much

[rajasekharreddy]

am very thankful to you have applied the same to my worksheet and it really tutorials save lot of man once

[cajatinaswani]

Every time I learn something new on this channel.
Great work Leila 👍

[machi]

This does the job as well:
=IF(COUNTIF(A5, "*AT*")>0, "AT", "")

[blankmedia]

You have some of my favourite content in the world. Thank you

[age_of_reason]

This was exactly what I was looking for and I was able to write my formula with IF + wildcards and it solved my problem. Thank you!

[abubakarshehuabubakar]

WOW! knowing this channel is like seeing water in the mids of the hot desert. Thank you, Laila. Much love!

[SteveGoebler]

This is something I've been trying to work out for some time now. Thank you!!!

[WaqqasAzeem]

Thank you... I searched everywhere but no solution... You're a life saver.