Index Match where names are not exact match.

[Godders199]

Hello, I am struggling with the correct formula, I have various sources of data, which contain names in diffferent formats, for example fred Smith and Fred S Smith.

I put together the following formula which i though would pick these names differences up within the "*"&'Instructions '!ls&"*" element of the formula.

=IFERROR(INDEX('Sharepoint history'!E:E,MATCH("*"&'Instructions '!L3&"*",'Sharepoint history'!H:H,0)),"")

But unfortunately it is only picking up exact matches, what do i need to change the formula to , to pick up effectively partial matches.

Any help would be appreciated.

 

[Godders199]

Hi all, I have worked this out so no response required, correct formula is

=IFERROR(INDEX('Sharepoint history'!E:E,MATCH(SUBSTITUTE('Instructions '!L3," ","*"),'Sharepoint history'!H:H,0)),"")