How Do I Automatically Hyperlink To The Reference In A Cell?

I'm using the formula below to automatically select the hyperlink location.

=HYPERLINK("#"&VLOOKUP(G27,EXERCISE_1LU,2,FALSE),"1B")

It works great with named ranges, but I want to get crazy and have the hyperlink result be an actual web address versus a defined range name. The result I'm getting is "Reference is not Valid"

I've used both the http:// prefix and only www. prefix. Neither worked. Any help would be greatly appreciated.

Sheet 1, cell A1 has the hyperlink.

Hyperlink details are ...
Type the "cell reference" is C1.
Select a place in this document: Cell reference 2 (sheet 2).

Formula required for "cell reference". I want the C1 to change on a daily basis, to the next row without having to edit the hyperlink.

Hi everyone,

I'm trying to figure out a formula (preferably formula, if not possible, then custom VBA formula) that determines whether the current cell is a hyperlink.

For example, is there a formula that looks like this?

=IF(ISHYPERLINK(A1),"This cell is a hyperlink","This cell is not a hyperlink")

Where A1 is the cell being tested.

Please let me know! I've searched the web and the forums for this without answer

Thank you!

Hello Everyone I have a hyperlink question and cannot find a solution anywhere.


Basic problem: i cannot figure out how to use HYPERLINK to Go to a cell in the same workbook.

Sub Problem: the cell that will contain the hyperlink will be dynamic based on a lookup.

=HYPERLINK(VLOOKUP(B1,DataArray,1,FALSE), "Link" )

Is this possible?
Could it be possible to write a GOTO function to do this if it cannot be done with formulas?


Thanks!

Hello,

I need to have a solution for the following excel requirement.

Assume that C5 has "some_val".
i need to look in the whole column of A for the cell value of "some_val" and i have to create a hyperlink to the matching cell.
(Assume that A15 has "some_val", then hyperlink in C5 should link to A15 automatically)

This process has to be automated as i have about >1000 cells. Hope i'm clear with my requirement!

Looking for some formula/vb script


Thanks in advance

This HAS to be a simple fix.... Could not find a string with this solution in it yet.

Trying to set up a hyperlink to reference another location in the same sheet.
Used the example in Excel as a model to set this up so placed this formula in cell B1:
=hyperlink([Book1]Sheet1!a1,"LINK")
this defaults to =hyperlink(Sheet1!a1,"LINK") since Book1 is the current wb.
clicking on "link" in cell B1 produces "Cannot open specified file" error.
I need the hyperlink to be dynamic, so I can't use the CTRL+K hyperlink function.

Thanks in advance for any help

I recieved help with this from the Board and it was great. As with all things it posed new questions.
Now that I can change the Active Sheet name automatically I want to be able to Hyperlink it to another sheet. What I do is set a hyperlink from a "Table of Contents" page. The problem now is that if the name of the page changes, the Hyperlink reference will no loger reference the page. Is there a formula that will change as the Active sheet name changes?
ie.
Cell $C$7 will change from Last Name, First name to another Last name/ First name. This will change the Reference and the hyperlink will no longer work. Is there a way I can have the Hyperlink ALWAYS reference this page, no matter what the name change?
Thanks in advance!!

Private Sub Worksheet_Change(ByVal Target As Range)

Dim Cell As Range
Dim Rng1 As Range

If Target.Address = "$C$7" Then
ActiveSheet.Name = Left(Target.Value, 12)
End Sub

I found this solution for "drop down list with hyperlink" but it did not work.

Perhaps a better solution is to use a workaround that relies on the HYPERLINK function to refer to whatever is selected in the drop-down list. For instance, if you have your data validation drop-down list in cell A1, then you might put the following formula in cell B1:

=HYPERLINK(A1, "Goto Link")

The solution directly above provides exactly what I am looking for
in the field where I write the formula, but it fails to hyperlink.
I have created a drop down list and linked each one of them to a
specific worksheet. When I select them individually they link to
appropriate worksheet. But when I select them in the drop down
list I receive the following error when I select the Hyperlink in
cell B1 as directed above.

"Cannot open the specified file"

Any thoughts?

Bob

I have an Excel document where I want to put text and a hyperlink in the same cell. . . . it appears to make all the words a hyperlink rather than just the hyperlink itself . . . do you have a solution?

ok i was wondering if this is even possible.
i want a hyperlink to reference to the contents of another cell example

REFERENCE TABLE

| A | B |
1 |Alexander | Sheet1 |
2 | Alona | Sheet5 |
3 | Alfie | Sheet3 |


Column A is the hyperlinks. column B is the exact name of another worksheet in this workbook. i want the hyperlink to reference to the cells in column B so when the hyperlinks are clicked the active (or visible) sheet is the sheet being referenced. example, when cell A1 (Alexander) is click it will take you to (reference B1) Sheet1. is this possible? i know i can make a simple hyperlink by right clicking and going to hyperlink and then just choose the "place in this document" but i have many many many many hyperlinks to make, i was hoping i can do it formula wise.

Greetings, I am using excel 2003 to create a pictorial directory for our church. On one worksheet I have ~200 pictures. On 13 other worksheets I have all of the addresses and such layed out. On a whim I started hyerplinking the pictures so that if you clicked on the persons picture you were taken right to their info - pretty straightforward stuff. But the thought just occured to me that if I add a new address here or there, all of the hyperlinks will need to be updated, or any of the ones after the new one anyway. I wonder if you can code the hyperlink to look for a cell value instead of a cell reference i.e. "Johnson" instead of "C4". I know that this is easy to do with the "=HYPERLINK" formula but not so sure about the object hyperlink. I looked through the message board and perused the excel help and did not really see anything. Anybody have any ideas? Thanks, RB

Hello all,

I have a formula like below with a HYPERLINK function inside an IF statement.

=IF(A3="red",HYPERLINK("http://www.google.com","GOOGLE"),"no link")

When cell A3 = red, the link works perfectly. However, when A3 does not equal red, the cell with this formula still appears as if it is a hyperlink. I get the hyperlink cursor when I hover over the cell, and when I click the cell I get an error message stating that the address of the site is not valid.

Is there any way to get rid of this error? If I write the formula like below I don't get the error, but this doesn't give me the result that I want.

=IF(A3="red",HYPERLINK("http://www.google.com","GOOGLE"),"")

Thanks,
Rick

Excel 2003

I have a series of hyperlinks in cells that display dates. I am looking for a formula that will reside in a different cell, that determines the latest (max) of these dates, and then will have a hyperlink that connects to the hyperlink of that cell.
That is, I would like to have hyperlink in a cell, and have it open the hyperlink of a different cell. The selection of that different cell is based on a determination as to whether the date displayed in that cell is the maximum value of a range of cells (each cell has different hyperlinks).
Thank you! in advance

I have a spreadsheet where I use columns a, b, & c to create a hyperlink.

Column in D2 is =hyperlink(a2&b2&".htm",c2).

This works fine. What I want is a worksheet that just has D2 in it with the associated hyperlink, so it would appear that I typed in c2, and did an insert hyperlink.

Then I would not have to have columns a, b, c. I know that I can hide those columns, but is there a way to just copy the contents of my resulting cell d to a new workbook?

Morning all
I'm trying to use a hyperlink based on a cell that has an indirect() ref to a worksheet which is named the same as the cell.
eg.
Index Sheet Cell Formula/Text
A1 Archer
B1 =INDIRECT("'"&A1&"'!A1")
C1 =HYPERLINK(B1)

now if the sheet 'Archer' Cell A1 had the text 'help' then the result of 'Index!B1 would be 'help' so I know the function is referring to the correct place in the workbook. How then do I get Index!C1 to hyperlink to Archer!A1

the reason for all this is that I want to create and navigate a workbook with 200+ tabs with an index using filters (ie. Index!ColA) then click on the result of the filter (Index!ColB) to jump to the correct tab (or use a lookup, either way is fine) so I want the hyperlink formula based so I don't have to Insert/Hyperlink each time (by the way I will be creating 4 of these so 1000 + hyperlinks).

I am addicted to the knowledge on this board...

What I currently have is a list of people that is created from references. Each person's name is also the name of a worksheet in the book. I want to take this name (output) and insert it into a hyperlink formula in the cell next to their name that would allow the user to quickly jump to their personal sheet.

I have tried this on a whim but it did not work...

=HYPERLINK("(D6)&!", (D6))

I was hoping that the value in cell D6 would be inserted and thus give me something like =HYPERLINK("Chris!", Chris) although I am not sure that is even the correct formula for linking to a worksheet.

Hi,

I'd like to create an hyperlink to the first blank (empty) row in column A of a sheet. Is it possible to use "Insert / Hyperlink" and input a formula in the "Type the cell reference" box?

If so, which formula? If not, is there another way (not using VBA), so that I can type in the hyperlink cell "Go to first blank row in column A" and actually go there by clicking in the cell?

Thanks for any help.

MrDoc

I have a path to a file in cell B10. I want cell b10 to be converted to a
hyperlink without needing to point to a different cell (which I can do with
the worksheet HYPERLINK function.

I want to do this programmatically via VB.

I have searched prior hyperlink questions and answers on this site but have
found my case.

Thanks,

Sandy

Want to know how I can combine formula
I want to hyperlink a cell that has a formula in it

Example:
have XXXXXX.com in onecell
Formula: add the www. to it to have results in another cell but it does not create a hyperlink

Using: =CONCATENATE ("www.",B1)

What do I need to make the end result a hyperlink ?

Hi,

I am trying to come up with formula to use HYPERLINK function.

IF A2="YES" THEN B2=HYPERLINK("\\c:temp\test.file")

I need cell B2 to show hyperlink based on the value of cell A2 (YES/NO).

Is this possible?

Thank you,
djanu