| View previous topic :: View next topic |
| Author |
Message |
rudagar
General User
Joined: 21 Jun 2005
Posts: 21
|
 Posted: Wed Apr 05, 2006 5:42 pm Post subject: "Dynamic" Sheet??? |
 |
|
I'm looking for a way to do something like this...
=A5.A1
A5 ould contain the sheet name... so let's say A5 is "Sheet9"... then it would be looking for ='Sheet9'.A1
I tried using =SHEET(A5).A1 and =SHEET(A5)!A1 but neither work.
Any ideas? |
|
| Back to top |
|
 |
rudagar
General User
Joined: 21 Jun 2005
Posts: 21
|
| Posted: Wed Apr 05, 2006 6:51 pm Post subject: |
|
|
Nevermind... found it
=INDIRECT(A5&".A1") |
|
| Back to top |
|
|
|
