INDIRECT("AnotherSheet!"&A3)

or
INDIRECT("'Another Sheet'!"&A3)
if there are spaces in your sheet name (note the apostrophes ' )


" 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