Hello Faseeh
I dont have problems with this formula
=INDEX('C:DC[Sales.xlsm]Elite'!$A$14:$X$439;$A28;T$12)
I'm trying to create a way to include a variable representing the path, file and range
ex:
Path='C:DC
File=[Sales.xlsm]
Product=Elite
Range=$A$14:$X$439
Then I could use...
Hello,
Good day to all.
I'm trying to automate some Sheets and I have a old problem with external links
I have this formula
INDEX('C:DC[Sales.xlsm]Elite'!$A$14:$X$439;$A28;T$12)
I have already try to create a range name like
FullPath='C:DC[Sales.xlsm]Elite'!$A$14:$X$439
Then try to...