Previous Topic Next Topic

Excel, If statement with part of text matchin

Closed
minseoul5 Posts 1 Registration date Friday March 26, 2010 Status Member Last seen March 26, 2010 - Mar 26, 2010 at 12:33 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 26, 2010 at 12:55 PM
Hi,

I would like to find out an if function or VBA code that will return a certain number if parts of a cell contains the text that I'm looking for.

For example,

A B
1 Deutsche Bank AG Deutsche


If cell A1 (Deutsche Bank AG) contains cell B (Deutsche), then I want to get a value "1" in C1.


Thanks much!



1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 26, 2010 at 12:55 PM
you can use FIND and SEARCH functions

=SEARCH(B1, A1,1)

=IF(ISERROR(SEARCH(B1, A1,1)), 0, 1)

etc
0