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
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?
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:
- Name check
- Check soft - Download - Finance
- Speaker check code - Guide
- Tmobile data check - Guide
- Check bios version - Guide
- Huawei touch check code - Guide
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
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
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