Link to other cell in another workbook with changing variable

[tlepola]

Hi,

In sheet2 I have a link to a value in a cell of sheet1, for example I have in C3 in sheet2 that =sheet1!A7, which gives me correctly the value of A7 from sheet1.

Now I want to define in one cell of sheet2 that from which row the value will be taken. For examle if I put 3 to cell C1 in sheet2, the value in C3 of sheet2 would change to =sheet1!A3.

[6StringJazzer]

Try this:

=INDIRECT("Sheet1!A"&C1)

C1 must contain a number or this will generate an error.

[6StringJazzer]

By the way, if the cell in Sheet1 is blank, you will get a 0 here. Let me know if that will be a problem.

[tlepola]

This solved the problem, Thanks. And the "returning zero" is not a problem.