Help needed with a formula

[erardag]

I am trying to get some values from a different workbook into my sheet.
The formula I am using is simple, like this:
='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D$59 what I want to do is to keep column numbers (i.e D) in
this formula, but to able to change the row number dynamic. For example
I want to point this number in a cell, so whatever I write into that
cell will become row number in the formula. Is there a simple way?

 

[Freemini]

Assuming the formula is in cell B1, you could amande it to :
=OFFSET('I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D$59,A1,0)

This will allow you to input a number in A1 to move the referenced cell
down, with A1=0 producing the contents of D59, A1=1 producing the
contents of D60 etc.

Hope this helps

Mike