How can I refer to a worksheet using text in a cell?

P

Preston

I'm trying to create a reference to another worksheet using the text in a cell.
For example I have a sheet called Tom, I put the text Tom in cell A1. I then
want to be able to refer to the worksheet Tom using the cell A1.
Is this possible?
 
S

Stefi

=INDIRECT(A1&"!A1")
gives you the value of cell A1 of sheet Tom.

Regards,
Stefi

„Preston†ezt írta:
 
D

Dave F

You can also make cell A1 a named range, TOM, and make reference to that
named range. The disadvantage to this method is that if you have reason to
change the value in A1, the named range will not also change to the new
value. But I believe the formula Stefi gives would do that for you.

Dave
 
J

Jack Sons

"Brevity is the soul of wit"

Yes, but long ago a very wise man said: (wrote) "Brevis esse laboro,
obscurus fio". (Horace, Ars Poetica 25/26 and, later, Quintilianus 9.3.65).

Jack Sons
The Netherlands
 
Top