relevant part in function only copied when dragged down

[sParis90]

Hey, I am having a small issue with a formula but it's driving me crazy.

ps: note that I am German, so the functions are in German as well so they differ a little bit, but that shouldn't matter

I have this formula:

=INDIREKT(""&$B$3&"!"&"$I2") -> indirekt is German for the indirect function

I have several sheets with Data and one sheet to analyze.

in B3 sheet 2) I type in which Data sheet I want to go to and then read out cell I2 there, which works fine. But as I drag down the formula in my analyzing sheet it only copies the function. what I would want is this:

=INDIREKT(""&$B$3&"!"&"$I2")
=INDIREKT(""&$B$3&"!"&"$I3")
=INDIREKT(""&$B$3&"!"&"$I4") etc...

Any ideas please?

[canapone]

-----------

sorry: double post

------------

[canapone]

Hi

maybe you need ROW (ZEILE)

Please Login or Register  to view this content.

Cheers

[sParis90]

it works! thanks a lot.

and if I want to drag to the right? so that the "I" changes to J, K, L etc...?

[martindwilson]

try
=INDIREKT("'"&$B$3&"'!"&ADRESSE(ZEILE($A2),SPALTE(A:A)+8))