Hi,
I have two reports.
In one csv report I have column A with User Name : John Smith. In column B i have some random strings…
I have second report of all users. Column A : user logon name : Jsmith12 and in column B I have display name : John Smith.
I have no control over report structure….

Problem is, that I can do import of first report only with user name and not display name.
So what I basically want to achieve is, that I insert in column B in first report, User logon name from second report. I will compare both display name and if they match, I need to insert user name. I can copy column A and B from second report to first report and use simple lookup, but it does not work.
Br,
Borut

Attached Files

sample.xlsx (8.9 KB, 11 views)