Hi Experts,
I'm using Excel 2007 and I would like to return true/false when a row contains any partial match with another column data. for Ex:
----------------------
A | B
----------------------
Full Name | Names
----------------------
JohnSmith | John
JoeJohn | Nora
SusanJackson |
NoraAlbert |
SaraJohn |
----------------------
I want to check if any part from the name in A1 matches any name from B:B and return true/false in C
So the result should be something like this :
--------------------------------------------
A | B | C
--------------------------------------------
Full Name | Names | Match
--------------------------------------------
JohnSmith | John | Yes
JoeBlack | Nora | No
SusanJackson | | No
NoraAlbert | | Yes
SaraJohn | | Yes
--------------------------------------------
I was using this function but it's only working with full match not partial :
=IF(ISNUMBER(MATCH(A1,B:B,0)),"Yes","No")
Looking forward to your help.