Forum Discussion
index and match to an array of a different workbook with an absolute reference
I try to index and match to an array of a different workbook with an absolute reference.
CTRL + SHIFT + I gives me a unique errorcode of 100068
Am I making a syntax code in the example below?
=index('X:\Folder1\Folder2\[Source_File.xlsx]Sheet1'!$V$5:$AU$136,match($L2,'X:\Folder1\Folder2\[Source_File.xlsx]Sheet1'!$V$5:$V$136,0),2)
1 Reply
- Doing an INDEX/MATCH calculation against an external workbook is quite slow. Especially when the workbook in question is on a networks share or -worse- in a Sharepoint or OneDrive location.
I would pull in that data from [Source_File.xlsx]Sheet1'!$V$5:$AU$136 using Data, Get Data, From File and do the lookup against the resulting range in your workbook.
