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?