Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Partial Match in Excel 2007

Avatar of Dido123
Dido123 asked on
Microsoft OfficeMicrosoft ExcelVB 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.