Hi ,


I have column A with thousand User display names. There a lot of duplicate user names. But I do not want to delete them..
I need to match column A with correct user login name.
I have added two columns, or I can use second sheet, where I have column B with user logon name and column C with display name.
I would like in column D add the values of column B. when Value in column C match with value of column A. So if there is a match between John Smith in column A with column C: John Smith , should in column D be value of his user name that match Jsmith12.
I have add a sample table.


column A column B column C column D
John Smith Jsmith12 John Smith Jsmith12
John Smith Jkrem John Krem Jsmith12
John Krem MSibher1 Mathiu Siber Jkrem
Mathiu Siber TMAris Thomas Maris MSibher1
Thomas Maris AZimer1 Anton Zimer TMAris
Thomas Maris LKurz Lilian Kurz TMAris
Thomas Maris TMAris
* * *
* * *
Anton Zimer AZimer1
Lilian Kurz LKurz
Lilian Kurz LKurz

Thank you.
Br,
Borut