Held dragging INDIRECT FUNCTION
Biff,
Your the man.
signed,
Mcfly
Biff wrote:
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]
If anyone can help me with this it would be much appreciated!
|