hyperlink question

[Arul]

Is it possible to create a hyperlink against a value rather than a cell?

 

[Frank Kabel]

Hi
what do you mean with this?

--
Regards
Frank Kabel
Frankfurt, Germany

Is it possible to create a hyperlink against a value rather than a

cell?

 

[David McRitchie]

Hi Arul,
Yes it is possible.

=HYPERLINK("#"&ADDRESS(MATCH("xyz",B1:B13,0),2), "xyz" )

if you don't want to see #N/A then insert the failing part of the formula and the
formula as follows:
=IF(ISERROR(MATCH("xyz",B1:B13,0)), "N/A", HYPERLINK("#"&ADDRESS(MATCH("xyz",B1:B13,0),2), "xyz" ))

Don't ask me why the second formula hyperlink works but does not show up as a hyperlink, I don't know. Probably because one part
of formula is a hyperlink and the other part is not.


You are looking for the value "xyz" (not case sensitive) in B1:B13
You should look up ADDRESS Worksheet Function and the
MATCH Worksheet Function in HELP for some details.