I got a bit lost in your explanation, but it seems like the customized
equivalent of

=INDIRECT(CONCATENATE("Sheet3!","B","7"),TRUE)

where the CONCATENATE builds the address of the cell whose value you
want should work for you...

Of course, you could use cell references to provide parts of the
address or the CHAR function, ie


=INDIRECT(CONCATENATE(J4,CHAR(66),"7"),TRUE)

Assuming that J4 on the local sheet has the text

Sheet3!

in it.

Hope this helps!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111480