Using an array formula as a hyperlink cell reference
On Oct 16, 9:09*pm, Gary''s Student
wrote:
Hi Travis
First update the array formula to put a # in front of it:
="#" & your_formula
If the above is in cell A1, then
=HYPERLINK(A1)
will produce a nice, clickable, hyperlink
--
Gary''s Student - gsnu2007k
It didn't work, so I'll just make sure I'm doing exactly the right
thing...
The formula is:
="'Sheetname'!H"&MATCH(C44&D$39,'Sheetname'!A:A&'S heetname'!C:C,0)
That results in the following, which is the cell reference I want to
point my hyperlink at.
'Sheetname'!H24
If I'm understanding you, I need to change the formula to:
="#"&"'Sheetname'!H"&MATCH(C44&D$39,'Sheetname'!A: A&'Sheetname'!C:C,0)
Resulting in the cell having the following value:
#'Sheetname'!H24
I do a hyperlink and point it at the cell that says #'Sheetname'!H24,
this should redirect me to 'Sheetname'!H24
But all that happens is the cursor sits there in the cell with the
formula.
Travis
|