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 4478 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!



Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses