Hi
just for beeing safe I would use
=INDIRECT("'" & $Z1 & "'!A3")

--
Regards
Frank Kabel
Frankfurt, Germany

"kraljb" schrieb im Newsbeitrag
...

You can do that with the following formula =INDIRECT($Z1 & "A3")

Although for your ease you may want to a dummy row with A3 etc in it
and just go =INDIRECT($Z1 & A$1)

Also, you should make sure that the Z dummy column includes the "!"
at
the end.


--
kraljb
---------------------------------------------------------------------
---
kraljb's Profile:
http://www.excelforum.com/member.php...fo&userid=9955
View this thread:
http://www.excelforum.com/showthread...hreadid=277570