Conditional hyperlink?

Y

y_not

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?
 
D

Dave Peterson

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

y_not

Thanks Dave,

I'm sure this will do what I'm looking for - just a bit slow with th
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 th
problem.

Have a good day

Ton
 
Top