How to read value from cell in formula INDIRECT?

[sh1ne]

Hi guys,

there is possible to read a value from cell where I put the name of sourcefile as "string" and naming that cell then use name of cell in formula excel?

for example:

as you see, the first table is working but before I run macro without choosing manually that file I need to put in on for example Mapped drive/sharedrive etc.
The next table is not working = always need to choose manually file, even if its opened in excel or in the same folder.
Want to add - In another IF(ISERROR(VLOOKUP(INDIRECT) example its working. What is wrong?

 

[mart37]

=VLOOKUP(RC[-2],INDIRECT("'"&sourcefile&"DC Table'!R2C2:R242C5",TRUE),4,0)

 

[sh1ne]

Thanks for reply, its working but meanwhile Ive solved that problem. Thx