What is a hyperlink?

Hyperlink functionality

• QUESTION: I am attempting to set up HyperLink that populates from a data validation answer. The hyperlink links to another worksheet in the same workbook. In this situation the end user (EU) selects an answer to a question and the answer populates in c5. In c6 the following formula is in place: =IF(C5="ANA 2.0", 'ANA 2.0 Rights'!B1) I have gotten this to work, but only once. I'm not sure what I am missing. Any insight would be most helpful. ANSWER: first, that isn't a hyperlink. It is just a link to another worksheet in the same workbook. It isn't clear what isn't working. Your formula looks ok except it refers to a sheet named ANA 2.0 Rights and from your picture there does not appear to be a sheet with that name. In myworkbook, I reproduced your formula but put in a sheet named ANA 2.0 Rights and the formula worked fine for me. See the attached image. since it works for me, I can only advise to set up your workbook similarly. -- Tom Ogilvy ---------- FOLLOW-UP ---------- QUESTION: OK. There definitely is a "ANA2.0Rights" worksheet created. When I created the formula I used the hyperlink function to create the the link for "ANA 2.0 Rights" worksheet. I right clicked on A2 of the ANA 2.0 Worksheet , clicked on HyperLink, set the rights to "this workbook", created the link (OK), copy pasted the link, went back to the "Rights" worksheet and inserted this into my (=if) formula located in C6 of the "Rights" worksheet. When I ghost over the populated link in C^ with mouse a box pops up telling me to click to go to link. So it looks normal, just when I go to click the link it doesn't take me to the "ANA2.ORights" worksheet. Can I have spaces within the names of the worksheets? Also, I'm looking for a recommendation in regard to a basic HTML software for building a website. This would be for novices.

• Answer:

  I can only advise you of what I can see. In your picture I see no hyperlink. I only see a linking formula which references an ANA 2.0 Rights worksheet and in you picture there is only a Main and a Rights sheet tab showing (two tabs, two sheets). If you put a hyperlink in one of the sheets, then I would suspect that would work if it is set up properly. In the hyperlink dialog, you would have to select the bookmark in some versions of excel, in Excel 2007 it has "Place in this document" to to complete the hyperlink and have it link to a sheet in the same workbook. I created a sheet with yout ANA 2.0 Rights name and created a hyperlink to it in another cell in another sheet in the same workbook. I then went to the VBA immediate window (doing this just to show you the property of the hyperlink) and queried the sub address: ? selection.hyperlinks(1).subaddress 'ANA 2.0 Rights'!A1 now if your intent is to only show the hyperlink if someone puts ANA 2.0 in cell C5, then you need to use the hyperlink worksheet function. Not the formula you have and you don't create the hyperlink by right clicking on the cell and selecting hyperlink (which makes a permanent hyperlink). =IF(C5="ANA 2.0",HYPERLINK("[Test Hyperlink.xls]'ANA 2.0 Rights'!A1","go to ANA 2.0"),"") is the formula I used and it worked fine. In this case, I put the formula in the workbook Test Hyperlink.xls and linked to the sheet ANA 2.0 Rights which also existed. the "go to ANA 2.0" is what is displayed in the cell (as a hyperlink) when ANA 2.0 is placed in cell C5. Otherwise the cell appears blank. this formula worked fine for me in the situation I described. hopefully that is actually what you want.