troubleshooting Question

Partial Match in Excel 2007

Avatar of Dido123
Dido123 asked on
Microsoft ExcelMicrosoft OfficeVB Script
18 Comments1 Solution515 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros