Lookup formula using part of string

Hi All,

Apologies if my question has been asked before. I have tried searching and found similar queries but none exactly matching what I need to do and I don't have the knowledge to make the necessary tweak to apply it to my particular situation.

Any help greatly appreciated !

I have a list of names separated by commas. E.g. Parker, Peter

I have separated this via text to columns.
I need to look up the name 'Parker' to a column, Column B, of names from a different source.

For example; I believe Parker, Peter to be in Column B, however I think he is there as Parker, John Peter.

I know how to do a lookup using ISNUMBER (SEARCH but what I don't know how to do is turn this into a vlookup so that I can return 'Parker, John Peter'.

So to confirm; I need Parker in Column A, to lookup and return 'Parker, John Peter' in Column B.

Thanks,
Alex