Need to create hyperlink to another hyperlink

[twinsfan79]

I need to be able to create a hyperlink to a cell in another sheet that also contains a hyperlink. I have tab A and B. Tab B contains a report. Tab A converts tab B into a different order for that information to go into another report. Some of the cells in tab B have a hyperlink to an internal database and the cell shows the friendly name. Is there a way to have tab A link to the cell in tab B where it will be the hyperlink with the friendly name?

Thank you!

[Tony Valko]

Need more details!

Here's an example...

Cell A2 contains this hyperlink formula:

=HYPERLINK("#A10","Go")

That takes you to cell A10.

Cell D15 contains this hyperlink formula:

=HYPERLINK("#A"&MATCH("Go",A:A,0),"Go")

That takes you to the hyperlink in cell A2.

[twinsfan79]

Okay I'm going to post an example. I need Cell A2 of the sheet translator to show a hyperlink, but instead of taking my to cell A2 of the sheet report it needs to actually open then link that is in cell A2 of sheet report.

[RedSummer]

Try

=HYPERLINK("http://www."&Report!A2&".com",Report!A2)

You have to pay attention to what you are calling you link's display name on your report tab. I don't really understand the point of having them identical, especially if it's a lookup page you might just want the full http://google.com on the report page and then hyperlink it on the translator?

Let me know if this works for you.

Red

[twinsfan79]

Thank you. When I use the formula it takes me to the report tab which is not what I need. I need the link on the translator tab to open up the link that is on the report tab. Google was just a placeholder. For my report the link goes to an internal company web site. Once I've dumped everything on the report tab, and take the translator tab and put it in yet another workbook.

[RedSummer]

When I use the formula it takes me to the report tab which is not what I need. I need the link on the translator tab to open up the link that is on the report tab.

Are you saying my formula above and in this worksheet doesn't bring up google.com in a webpage? Because it's doing so for me.
Testv2.xlsx

Red