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

Hi
what do you mean with this?

--
Regards
Frank Kabel
Frankfurt, Germany

"Arul" schrieb im Newsbeitrag
...
Is it possible to create a hyperlink against a value rather than a
cell?

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.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Arul" wrote in message ...
Is it possible to create a hyperlink against a value rather than a cell?