hyperlink to value

icestationzbra · Sep 30, 2004

david,

thanks for your reply.

when i use this formula:

=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

i get N/A#.

regards,

mac.

Dave Peterson · Sep 30, 2004

Do you have a worksheet named "sheet two"?

david,

thanks for your reply.

when i use this formula:

=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

i get N/A#.

regards,

mac.