Matching name formula

[anaranjo]

FDibbins helped be with a formula to match names from one worksheet to cells in antother worksheet. However, when I originally asked I forgot to mention that some of the names in the cells have a middle name or initial included. So, the formula is working fine - except on the names that have a middle name or initial. In that case, it is returning a 'Not Found.' Can somebody help to revise the code to maybe ignore the middle initial?

Thank you.
A~

=IFERROR(INDEX(spGangID,IFERROR(IFERROR(IFERROR(MATCH("*"&$E13&"*",template!K$2:K$250,0),MATCH("*"&$E13&"*",template!M$2:M$250,0)),MATCH("*"&$E13&"*",template!AC$2:AC$250,0)),"")),"Not Found")

[oeldere]

Why not stay in your earlier post, and add the question in a excel file.

[anaranjo]

Thank you for the advice. I did post this question in my earlier post and have not received a reply so that is why I moved it here.

[oeldere]

In that case I need to search in the forum to find the file (in your earlier question).

Staying in your earlier question also has the advantage that we can see which solutions are already offered.

[anaranjo]

Here is the link - if it helps.

http://www.excelforum.com/excel-form...e-columns.html