Name check

Ask a question kalai - Last answered on Oct 4, 2017 at 02:27 PM by Mazzaropi

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?
plus moins
Kalai, Good afternoon.


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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!