Using the wildcard with IF

[DamienO]

Hi all,
I'm trying to set up a message that will generate from an IF formula. At the
moment I'm at:

=IF(E3="*C3","","Please check that you have chosen")

The content of C3 is a part of the content in E3 e.g. E3=161426 oxygen and
C3=oxygen. I want to check that what is in C3 is also in E3 and, if not, put
up a message. All help appreciated.

 

[T. Valko]

Try it like this:

=IF(COUNTIF(E3,"*"&C3),"","Please check that you have chosen")

 

[DamienO]

Thanks a lot. That works perfectly

Try it like this:

=IF(COUNTIF(E3,"*"&C3),"","Please check that you have chosen")

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Shane Devenshire]

Hi,

Here is another approach

=IF(ISERR(FIND(C3,E3)),"Please check that you have chosen","")


If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[T. Valko]

Note that FIND is case sensitive.

Oxygen and oxygen will not match.

Might be better to use SEARCH which is not case sensitive.