Dragging down Indirect Formula

[MROMAR]

So I have the formula =(INDIRECT("'"&$A$2&"'!E2"))

When I drag it down I want it to be =(INDIRECT("'"&$A$2&"'!E3")), =(INDIRECT("'"&$A$2&"'!E4")) etc.

But the E2 never changes

Is there a way I can do this, as I do not want to manually edit each cell.

[Nels]

Try this formula see if this helps,

Please Login or Register  to view this content.

[Pete_UK]

Do it like this:

=INDIRECT("'"&$A$2&"'!E"&rows($1:2))

then copy it down.

Hope this helps.

Pete