Getting the values in an excel based on a matching column in the another excel document

[GeoJul]

Hello

I need a help on my problem.


I have the first excel document 'Sharepoint.xlsx', where I have the column named 'Column1' which has the values like:

S15-04109-01
S15-01049-01
S15-05147-SM-003
S16-02411-01-006

There are two other columns in 'Sharepoint.xlsx' namely 'Modified On' & 'Modified By' which is having some value against each of Path column values,
which has the values like:

Modified
---------
2/4/2016 11:24:24 AM
11/18/2015 5:38:08 PM

Modified By
-------------
Markus Holaschke
Calin Costea

There is a second excel document 'ARM KPI', there is a column called Trialcode which is to be compared with Column1 in 'Sharepoint.xlsx' document.

If matches, it should paste the 'Modified On' & 'Modified By' value against 'Column1' in the second excel document 'ARM KPI' columns namely 'ARM file upload date' and 'Uploaded by'

This is the requirement.


I am using the below formulas in the column 'ARM file upload date'

=IFERROR(INDEX([Sharepoint.xlsx]prod_activity_edm!$D:$E,MATCH(A2,[Sharepoint.xlsx]prod_activity_edm!$N:$N,0),1),"")

AND

'Uploaded by'

=IFERROR(INDEX([Sharepoint.xlsx]prod_activity_edm!$D:$E,MATCH(A2,[Sharepoint.xlsx]prod_activity_edm!$N:$N,0),2),"")

But not able to fetch the data. What might be the reason?


I am sharing my excel documents for easy understanding. Please access through the links below:

https://www.dropbox.com/s/w9vod4wsgs...point.xls?dl=0

https://www.dropbox.com/s/rjffwiomj9...0KPI.xlsx?dl=0

Thanks in advance.

 

[arthurbr]

Cross posted without links
Fetching the values in an excel based on a matching column in the another document
http://www.excelforum.com/showthread...19#post4412619
https://social.msdn.microsoft.com/Fo...forum=exceldev