Using a lookup in a part of another 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?

 

[Allen]

I think what you need to do is play around with the dollar
$ signs in your formula.

Your formula:
='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D$59

New formula (always refers to column D, but row will vary
depending on the cell where the formula is):
='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D59

Allen

 

[masim]

instead of ='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D$59


try this

='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!$D59


and copy down

Regards
Asim

 

[Anon]

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?

Do you mean that you want a cell (say $E$1) that has in it the value 59, and
your formula will work as above, but that if you changed the value in $E$1
to 63, your formula would work as though it were
='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik vs).xls]2'!$D$63
?

If so, try this:
='I:\ORKUN\Konya\Istatistik\[BINASAYIMI(Balikesir Gemlik
vs).xls]2'!OFFSET($D$1,$E$1-1,0)

 

[erardag]

Nope, these don't work...