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.

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.

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.

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.

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.

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.