View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Singh Singh is offline
external usenet poster
 
Posts: 28
Default 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.