Making a hyperlink from a formula

**protocoledu** · 12-17-2009, 08:01 AM

Is this possible at all?? The forumla i have is;

Please Login or Register  to view this content.

The cell G7 will have a postcode in this and i would like it to be a 'clickable' link so if once they put the postcode in they just can click to bring up IE with that web address!!

**DonkeyOte** · 12-17-2009, 08:03 AM

See HYPERLINK function, ie:

Please Login or Register  to view this content.

**scaffdog845** · 12-17-2009, 08:12 AM

or click INSERT --> HYPERLINK which is also CTRL + K on your keyboard

**DonkeyOte** · 12-17-2009, 08:17 AM

scaffdog, the URL is itself dynamic by means of a variable (G7)

**Jack in the UK** · 12-17-2009, 08:33 AM

You can hyperlink almost anywhere

Add this into a cell, its what i generally do

=HYPERLINK("#"&CELL("address",Sheet2!A1))

Now the cell will read - #[Book1]Sheet2!$A$1 this is expected

**scaffdog845** · 12-17-2009, 08:54 AM

Originally Posted by DonkeyOte

scaffdog, the URL is itself dynamic by means of a variable (G7)

I should have read it a bit more thouroughly. Nice for future use!

**DonkeyOte** · 12-17-2009, 09:07 AM

Originally Posted by Jack in the UK

You can hyperlink almost anywhere

Add this into a cell, its what i generally do

=HYPERLINK("#"&CELL("address",Sheet2!A1))

Now the cell will read - #[Book1]Sheet2!$A$1 this is expected

Yep, in this case though the link is a URL - hence post #2