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?

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),sheetone!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

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