hi
I am having some difficulty importing data from one file to another and wondered if I might seek some assistance.
The code I have been using for ages allows me to import data from various files into a single central file without issue, but I am now trying to bring data into a different file and it is simply not working.
Here is the code that works to bring data in
Code:
=IF(ISERROR(MATCH(1,INDEX((INT('VDW-November-2017.csv'!A$2:A$10000)=A3)*('VDW-November-2017.csv'!J$2:J$10000=D3),),0)),"",INDEX('VDW-November-2017.csv'!P$2:P$10000,MATCH(1,INDEX((INT('VDW-November-2017.csv'!A$2:A$10000)=A3)*('VDW-November-2017.csv'!J$2:J$10000=D3),),0)))
Depending on the location of the data I require, file name, column and row references change, but essentially it is the same code. It has worked for ages into the same single central file.
So what would be causing the same code not to be working at all when I try to import into a different file? No matter what I do, I cannot get any data at all to import; the result is simply a blank cell
Any help gladly accepted
Regards