In Sheet1,
I got this rendition to work ok:
=HYPERLINK("#"&CELL("address",INDIRECT("'"&A3&"'!A 1")),A3)
where in A3: Sheet2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,900 Files:354 Subscribers:53
xdemechanik
---
"Hershey" wrote:
I'm trying to create a hyperlink in a cell on Sheet1 to cell A1 in Sheet2.
The value of Sheet1!A3 is Sheet2.
I'm entering this formula, and no error value is returned, but it just
doesn't go there.
Here is the formula:

=HYPERLINK(INDIRECT(MID(CELL("filename"),FIND("[",CELL("filename")),FIND("]",CELL("filename"))-FIND("[",CELL("filename"))+1)&A3&"!$a$1"),A3)

Any ideas?