PDA

View Full Version : Hyperlinks and Cell references



catharsis50
03-22-2012, 11:09 AM
I've got one column that lists different URLs and one column that has the name of where that URL goes. Is there a way for me to have the hyperlink for the the named column to use the URL in the URL column.

Example: Title is in A1 URL is in B1

Hyperlink address: =B1
*I tried this and didn't have any luck but would like the hyperlink to function that way.

Thanks!

CatDaddy
03-22-2012, 11:13 AM
try =HYPERLINK(B1)

catharsis50
03-22-2012, 11:40 AM
I wasn't utilizing the whole Hyperlink function. If you use =hyperlink(URL Cell,Use friendly cell reference here) it will display the name or text you choose as the "friendly name"