Looks like kind of lookup but...

[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?

 

[dvt]

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?

The INDIRECT function is probably what you want. Something like this:

=INDIRECT("'I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D$" & A1)

where A1 contains the number 59 (or whatever row you wish to find).

 

[Steve Smallman]

Try '="I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!D" & A2'

where A2 contains the row number you are looking for

Steve