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.