Name check

kalai - Oct 4, 2017 at 09:51 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- 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?
See more 

Your reply

1 reply

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Oct 4, 2017 at 02:27 PM
0
Thank you
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
Respond to Mazzaropi