Put this in B1 -- not A1. The formula uses the value in A1 to create the
hyperlink.

And change 'Sheet 2' to match the name of the sheet that you want to jump to.

In one of your messages, you used "sheet 2". I thought that this was the name
of the sheet.



mbqc wrote:

When I place the string
=HYPERLINK("#'sheet 2'!A"&MATCH(A1,'Sheet 2'!A:A,0),"Click me")
Into Cell A1 on Sheet 1 it overwrites the name Apple and when I paste
and hit enter I get a pop up window titled "Update Values: Sheet2"

Ideas?

--
mbqc
------------------------------------------------------------------------
mbqc's Profile: http://www.excelforum.com/member.php...o&userid=34207
View this thread: http://www.excelforum.com/showthread...hreadid=574395

--

Dave Peterson