Using the wildcard with IF
 

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.

Using the wildcard with IF
 

Try it like this:

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

--
Biff
Microsoft Excel MVP


"DamienO" wrote in message
...
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.

Using the wildcard with IF
 

Thanks a lot. That works perfectly

"T. Valko" wrote:

Try it like this:

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

--
Biff
Microsoft Excel MVP


"DamienO" wrote in message
...
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.

Using the wildcard with IF
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DamienO" wrote in message
...
Thanks a lot. That works perfectly

"T. Valko" wrote:

Try it like this:

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

--
Biff
Microsoft Excel MVP


"DamienO" wrote in message
...
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.

Using the wildcard with IF
 

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


"DamienO" wrote:

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.

Using the wildcard with IF
 

Note that FIND is case sensitive.

Oxygen and oxygen will not match.

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

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
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


"DamienO" wrote:

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.