mike1439 -
Jul 12, 2009 at 11:12 PM - Latest reply: gangsta
- Jul 4, 2011 at 12:13 PM

- Match names in excel
- Excel partial match two columns
- COMPARING TWO COLUMNS OF NAMES IN EXCEL [Solved] (Solved) » Forum - Excel
- How to match names in excel » Forum - Excel
- Excel 2003: Match Names; View Unfound Matches » Forum - Excel
- Matching names in different excel sheets » Forum - Excel
- Matching names in two columns of excel [Solved] » Forum - Excel

if your value is in column A & B starting from Row 2 then try this formula by writing in B2

=MATCH("*"&LEFT(A2,5)&"*",B2:B29,0) now drag it down ...

It will pick first 5 char from cell A2 then compare to column B and if found in column B anywhere then will return its number which you can be placed with if condition ......

=MATCH("*"&LEFT(A2,5)&"*",B2:B29,0) now drag it down ...

It will pick first 5 char from cell A2 then compare to column B and if found in column B anywhere then will return its number which you can be placed with if condition ......

Was this answer helpful? Yes No

I have two lists of personnel names, a master list in A2:A2651 and a growing list in B2:B?. I need to find names in the growing B list that are also in the master A list. Using "Help" I made an array formula for exact matches that works: {=IF(OR(EXACT(B2, $A$2:$A$2651)),"EXACT MATCH","")}

Now, I've realized, on some occasions, on either list, the middle initial is included. Of course, these matches are overlooked by the exact match formula. So, I am making a partial match formula, but it won't quite work, yet. Here's what I'm trying.

=IF(ISNUMBER(SEARCH(B2,$A$2:$A$2651)),"PARTIAL MATCH","")

Any solutions would be much appreciated.

Now, I've realized, on some occasions, on either list, the middle initial is included. Of course, these matches are overlooked by the exact match formula. So, I am making a partial match formula, but it won't quite work, yet. Here's what I'm trying.

=IF(ISNUMBER(SEARCH(B2,$A$2:$A$2651)),"PARTIAL MATCH","")

Any solutions would be much appreciated.

Mike,

I'm trying to do something similar.....match Legal company names with company names used by the GL; Often one will say "Corp." and the other will say "Corporation," so my v-lookup comes back #N/A. When you used the match formula, a number is returned.....what does that number represent? I've tried to use the match formula suggested, and it returns a number, but I have no idea what the number represents!

Thanks,

Stacey

I'm trying to do something similar.....match Legal company names with company names used by the GL; Often one will say "Corp." and the other will say "Corporation," so my v-lookup comes back #N/A. When you used the match formula, a number is returned.....what does that number represent? I've tried to use the match formula suggested, and it returns a number, but I have no idea what the number represents!

Thanks,

Stacey

The number represents the cell the value is in, if the value is #n/a then it means that it has not been located in the list

- Member requests are more likely to be responded to.
- Members can monitor the statuses of their requests from their account pages.
- A CCM membership gives you access to additional options.

good

thanks