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.