Conditional hyperlink?
 

Hi, I am wanting to have a hyperlink in a worksheet which will link to
one of two other worksheets depending on the entry in another cell.

e.g. sheet 1 (A1) possible options are "A" or "B"

If the entry is "A" hyperlink to worksheet 2
If the entry is "B" hyperlink to worksheet 4

The hyperlink is at cell (A7)

Is this possible or an I asking too much of Excel, please?


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=487954

Conditional hyperlink?
 

One way:

=HYPERLINK("#"
&IF(A1="A",CELL("address",Sheet2!A1),CELL("address ",Sheet4!A1)),"Click me!")

(all one cell)

Save this for later...

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)



y_not wrote:

Hi, I am wanting to have a hyperlink in a worksheet which will link to
one of two other worksheets depending on the entry in another cell.

e.g. sheet 1 (A1) possible options are "A" or "B"

If the entry is "A" hyperlink to worksheet 2
If the entry is "B" hyperlink to worksheet 4

The hyperlink is at cell (A7)

Is this possible or an I asking too much of Excel, please?

--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=487954

--

Dave Peterson

Conditional hyperlink?
 

Thanks Dave,

I'm sure this will do what I'm looking for - just a bit slow with the
old grey matter so I'll look at it again this evening.

Many thanks

I will post back once I understand how it works and if it solves the
problem.

Have a good day

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=487954