Extracting a word from a string to turn on a formula in an If Statement using a wildcard

[bearcub]

I would like to turn on a formula based upon a word in a string.

I have titles and I want to find certain words which will trigger a formula to populate a series of dates based upon a certain word in a string.

Is this possible to do? I thought I could do this with a wildcard in the following formula but it obviously isn't working.

In the following example I would like to have the word "account" used to trigger the "Y" results in another cell using the following if statement. Is this set up properly or is there another way to accomplish this:

Senior Account Representative
Formula (what I have now) =IF(F9="* Account","Y", "").

I would like to return "Y" but the formula is returning "".

 

[Fluff]

How about

=IF(COUNTIFS(F9,"* account"),"Y","")

 

[offthelip]

try this:

=IF(IFERROR(FIND("Account",F9)>0,FALSE),"Y","")

 

[bearcub]

I think I am trying to create a "fuzzy" match where if the cell contains a certain word in the text string. Are fuzzy matches possible in Excel using wildcards like I am using it

 

[Fluff]

You cannot use a wild card the way you tried. Have you tried either of the suggestions?
Mine will only find " Account" at the end of the string, as you were trying to do & offthelip's will find "Account" (without a leading space) anywhere in the string.

 

[bearcub]

thank you, tried the formulas and using the find formula works great. So I guess in a fuzzy match it would be best to use the find function to find a word in a string?

 

[Fluff]

It just depends on exactly what your data is & what you are trying to do.
Find is case sensitive & will find cat in "the cat sat on the mat" & in "He won the decathlon"

 

[bearcub]

Thank you. That's right, Find is case sensitive and Search is not