Logical statement for 'contains' ?
 

Is there a logical statement to return 'True' if one cell contains the
contents of another (and maybe more).

E.g.
Cell 1 = 12345
Cell 2 = 123456789
Cell 3 = 987654321

Logical statement would return true for cell 1 against 2, but not for cell 1
against 3.

Thanks.

Logical statement for 'contains' ?
 

Where j5 is what you seek

=IF(ISERR(FIND($J$5,J6)),"no","yes") yes
=IF(ISERR(FIND($J$5,J7)),"no","yes") no
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Singh" wrote in message
...
Is there a logical statement to return 'True' if one cell contains the
contents of another (and maybe more).

E.g.
Cell 1 = 12345
Cell 2 = 123456789
Cell 3 = 987654321

Logical statement would return true for cell 1 against 2, but not for cell
1
against 3.

Thanks.