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.