Dynamic Range using indirect and offset

[Jeffatwork]

I'm attempting to reference a named range, however, I'm unable to reference the exact worksheet. This works fine when I'm in this worksheet, but when I'm referencing this named range from another worksheet it doesnt work. What am I missing?

=OFFSET(INDIRECT(Tournament!$T$4),0,0,COUNTA(Tournament!$B:$B),COUNTA(Tournament!$24:$24)-1)


Thanks in advance

 

[xenou]

Hi, welcome.

What's the value in cell Tournament!$T$4

Regards,
ξ

 

[Jeffatwork]

$B$2 .... which is the upper left corner of the range I am naming.

I figured it out, see below
=OFFSET(INDIRECT("'Tournament'!"&Tournament!$T$4),0,0,COUNTA(Tournament!$B:$B),COUNTA(Tournament!$24:$24)-1)


Thanks,


Jeff

Hi, welcome.

What's the value in cell Tournament!$T$4

Regards,
ξ