Avatar of Dido123
Dido123

asked on 

Partial Match in Excel 2007

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.
Microsoft ExcelMicrosoft OfficeVB Script

Avatar of undefined
Last Comment
Rory Archibald

8/22/2022 - Mon