Mar 07 2023 02:32 AM - edited Mar 07 2023 02:40 AM
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)
Mar 07 2023 08:57 AM