hyperlink function

[Larry]

I am trying to use the hyperlink function. It wasn't working for me so I
tried in a blank workbook to make a simple hyperlink with the hyperlink
function using the function wizard. I added a value to the cell I linked to
on a different sheet. When I clicked on the hyperlink I received this
message. "The address of this site is not valid. Check the address and try
again". This is the formula I used. =HYPERLINK(Sheet3!C5,"NOW"). Do I
have something set wrong or what am I doing wrong?

 

[Joel]

Larry: The Hyperlink function is used to open other owrkbooks. Below is the
HJelp on the Hyperlink. If you want to add hyperlinks in the same document
click the right mouse button on the cell you want to add the hyperlink.
Select hyperlink and "select Place in this documnet"

Hyperlink()
Creates a shortcut or jump that opens a document stored on a network server,
an intranet, or the Internet. When you click the cell that contains the
HYPERLINK function, Microsoft Excel opens the file stored at link_location.

 

[Max]

Perhaps you were thinking of something like this ..

Assuming sheetnames listed in A2 down, cell refs in B2 down, Friendly names
(for the links) in C2 down, place in say, D2:
=HYPERLINK("#"&CELL("address",INDIRECT("'"&A2&"'!"&B2)),C2)
Copy D2 down to return the required hyperlinks

Eg if you have in A2: Sheet3, in B2: C5, in C2: NOW
D2 will return a hyperlink named "NOW" which will zip you to Sheet3's C5

 

[Larry]

I am trying to use a hyperlink to go to a named range depending upon the
values of two cells concatenated together. Here is what have.
=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!R1:AP4,2,FALSE))),"PRESS TO
SELECT") The lookup is necessary because of varying values. This returns
the proper named range but when I click on it it says "Cannot open specified
file".

 

[Max]

=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!

R1:AP4,2,FALSE))),"PRESS TO SELECT")

This revision of the above worked fine over here:
=HYPERLINK("#"&CELL("address",INDIRECT(C5&HLOOKUP(C3,Master!R1:AP4,2,FALSE))),"PRESS TO SELECT")