Held dragging INDIRECT FUNCTION

[ChronicTiger]

Im using this function.........

INDIRECT($A$2 & "!Q1")

When I drag it down a column I want the Q to increment.

If anyone can help me with this it would be much appreciated!

 

[Biff]

Hi!

Try this:

=OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1)

When copied down will return references to:

Sheet!???Q1
Sheet!???R1
Sheet!???S1
Sheet!???T1
etc

Biff

 

[ChronicTiger]

Thanks I'll keep that one in my arsenal. I am also trying to modify your
equation to get it to return references to:

sheet!???Q1
sheet!???Q2
ect....

can you help with that?

Thanks Biff..................

Hi!

Try this:

=OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1)

When copied down will return references to:

Sheet!???Q1
Sheet!???R1
Sheet!???S1
Sheet!???T1
etc

Biff

Im using this function.........

[quoted text clipped - 3 lines]

If anyone can help me with this it would be much appreciated!

 

[Biff]

Hi!

Try one of these:

=INDEX(INDIRECT(A$2&"!Q:Q"),ROWS($1:1))

=OFFSET(INDIRECT(A$2&"!Q1"),(ROWS($1:1)-1)*1,)

Biff

Thanks I'll keep that one in my arsenal. I am also trying to modify your
equation to get it to return references to:

sheet!???Q1
sheet!???Q2
ect....

can you help with that?

Thanks Biff..................

Hi!

Try this:

=OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1)

When copied down will return references to:

Sheet!???Q1
Sheet!???R1
Sheet!???S1
Sheet!???T1
etc

Biff

Im using this function.........

[quoted text clipped - 3 lines]

If anyone can help me with this it would be much appreciated!

 

[ChronicTiger]

Biff,

Your the man.

signed,
Mcfly

Hi!

Try one of these:

=INDEX(INDIRECT(A$2&"!Q:Q"),ROWS($1:1))

=OFFSET(INDIRECT(A$2&"!Q1"),(ROWS($1:1)-1)*1,)

Biff

Thanks I'll keep that one in my arsenal. I am also trying to modify your
equation to get it to return references to:

[quoted text clipped - 28 lines]