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 :


Looking forward to your help.
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