Hi,
I can't upload my original file, but I added a file with an example for the next quastion:
I have an excel file that need to get alot of data from other files.
As you can see in the example file, every cell in my table should get a value from another file.
There is a columne in the right with the names of the files that the data should get from.
I want to drag the formula in the cells with the current value of #REF to all the other cells in the table, but I need that the name of the file will update by name that's written in right column.
In the other files I always copy the cells from the same place.
I have already tried formulas like this one: =INDIRECT("["&G2&".xlsx]Work!"&"E29"), but the problem is that E29 do not update when I drag the formula.
I also tried this one, but the formula do not recognize the inner INDIRECT:
=INDIRECT("["&G2&".xlsx]Work!"&INDIRECT(E29))
What can I do???
Example4.xlsx
Bookmarks