Name check

Closed
kalai - Oct 4, 2017 at 09:51 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 4, 2017 at 02:27 PM
Hello,

How to check the name with two cells. if any part name matched with second cell, it have to be show as TRUE. What formula for this?
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 4, 2017 at 02:27 PM
Kalai, Good afternoon.

Suppose:

A1 --> Beethoven
B1 --> Ludwig van Beethoven

Try to do:

C1 --> =IF(ISNUMBER(SEARCH(A1;B1)),"TRUE","Not Found")

Please, tell us if it worked as you desired.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0