Vlookup, Find or VBA
Posted by Darren on August 15, 2001 10:58 PM
Assistance with the following problem would be appreciated.
I have two worksheets one has an person id code in one column and a surname in the second column. The second worksheet contains a column of full name, some of these contain initials.
I would like to be able to take surname and where surname is found as part of full name insert person id into an adjacent column.
If not this then seperate all the other information out of full name and insert just the surname portion into a adjoining column.
There is likely to be many duplicates of surname, I can work on this later.