INDIRECT("AnotherSheet!"&A3)


" wrote:

On Nov 19, 7:27 pm, "T. Valko" wrote:
Try this:

=INDIRECT(A3)

Ah, thanks, Biff... that works great. Although now I have another
question... what if the cell that I want to reference is on another
sheet? Excel seems to be choking on something like AnotherSheet!
INDIRECT(A3).

Is there a way to do this?

Thanks again!

-Ben