Match surname list to a surname and initials list, names have 1 or 2 initials.

[MrsExcell2013]

Please can anyone help me, is there a formula I can use to match a column that has initials and surname together with no gaps or anything separating the initials from the surname, some of the names have one initial & some have two initials. How can I can match another list of just the surnames to pull out the matching surname and initials to save me manually looking up if the person has one or two initials?
Thank you

[popipipo]

can anyone help me

Not without a xls sample

[MrsExcell2013]

It's just a plain excel worksheet, column A = data source with all of the initials and surnames together, column B just surnames, what i need is to match the surnames from collumn B to column A & populate column C finding/ matching the same surname in column A & putting the name with the initials in cell C. I could do it if they all have 1 or all have 2 initials but because I don't know if they have 1 or 2 initials I'm a bit stuck.

A B C
jhhill hill Jhhill
hjones blogs jsblogs
hasmith
jsblogs

[FDibbins]

This will help if you only have 1 instance of each last name (unlikely)...

=vlookup("*"&B1,A1:A10,1,false)

[MrsExcell2013]

Many thanks I will test this later, am I correct in thinking this will bring the closet match, if so that's just what I need, so if I have two people I need to check with the same surname I can just put one initial with the surname and it will tell me the closet match in column C so i will be able to see if the persons username has one or two initials.

Im just currious, Is there a way that if there are more than one surname the same to tell it to put it in column D, or E if there are 3 people with the same surname?