Using the wildcard with IF

  • Thread starter Thread starter DamienO
  • Start date Start date
D

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.
 
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
 
Note that FIND is case sensitive.

Oxygen and oxygen will not match.

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