Like function in an If statement

[Samantha78]

Hi,

I love using the like function in excel - "*"&cell&"*"

At the moment I am trying to use that within an if statement and I can't make it work - this is what I am trying to do.

=if(A1="*"&A2&"*","OK",0) - it works for sumif, lookups etc.

I need to compare two lists of suburbs - if they match, or are similar I need an OK, and if they are not to flag them.

Any ideas? I don't know how to use VBA very well.

Many thanks

Sam

[Ron Coderre]

Perhaps one of these regular formulas will work for you:

=IF(COUNTIF(A1,"*"&A2&"*"),"OK",0)

or...with some meageer error checking:

=IF((A2<>"")*COUNTIF(A1,"*"&A2&"*"),"OK",0)

Does that help?

[Samantha78]

Thank you it works well!