INDEX Function on Variable Filename

Originally Posted by Pepe Le Mokko

Perhaps =INDEX("'D:\Document\["&C2&".xlsx]Sheet1'!D:D",2567)

Pepe, that formula still doesn't work and results in an error.