Report

Name check

Ask a question kalai - Last answered on Oct 4, 2017 at 02:27 PM by Mazzaropi
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?
Helpful
+0
plus moins
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
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!