Held dragging INDIRECT FUNCTION
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
"ChronicTiger" <u17652@uwe wrote in message news:5a5cb72708eef@uwe...
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..................
Biff wrote:
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!
|