Issue with indirect formula

[richard1234567891011]

Hi, guys,

I am using this formula in order to copy data from another worksheet.

=INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G2")

Now I need to pull dow this G2, but obviously I can't now with this formula. I think I need to add in this formula something with the row, something like (ROW()-3)*1;0). But I don't know how to add it.

So, I need a formula like this: =INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G2") to pull down in order to catch also the other data down.

Thank you guys,

 

[richard1234567891011]

In which cell is your formula located ...???

The formula is located in the file where I need to take the data. EU_Export costi immobiliari.XLSX is the file with the data. G2 is the cell in the file with the data.

 

[James006]

The formula is located in the file where I need to take the data. EU_Export costi immobiliari.XLSX is the file with the data. G2 is the cell in the file with the data.

Understand the original source data is located in cell G2 ...

But regarding the destination cell where the formula is located ... which cell is it ...???

 

[richard1234567891011]

G2, G3, G4 and so on.

Yes, your formula is perfect! It is what I wanted. Thank you very much.

 

[James006]

Glad you could fix your problem ...