index and match to an array of a different workbook with an absolute reference

Copper Contributor

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.