Excel Hyperlink problem 1

[LScharf]

I have a workbook with two sheets and a range called 'guidance' on sheet2. I need to create a hyperlink on sheet1 to get the user to sheet2, based on a value lookup. So far I've got this:

=HYPERLINK(CELL("address",INDEX(guidance,MATCH(C6,INDEX(guidance,,1),0),1)), "Go")

The CELL function returns a valid address (in the form of: '[filename]rangename'!$A$1) but clicking on the hyperlink doesn't work ("Cannot open the specified file.").

Any ideas? Thanks!

 

[Gavona]

Try [filename.xls] rather than simply [filename]

Gavin

 

[GlennUK]

Put a "#" in front of the CELL, like "#"&CELL


Cheers, Glenn.

Beauty is in the eye of the beerholder.