+ Reply to Thread
Results 1 to 5 of 5

Hyperlinks & Vlookups

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Hyperlinks & Vlookups

    Ive recently taken a few cells and added a hyperlink in each to their own respective files. In a separate sheet I've used the vlookup function to pull those file locations from the previous cells described. The problem im experiencing is that the hyperlinks do not get carried over to the new sheet. I can still copy the file locations displayed in those vlookup cells and paste them into file explorer or the windows search and they will open just fine. But it would be even more convenient if the hyperlinks would get transferred over to the new sheet as well. I believe the issue im experiencing is because the cells and their contents i would like to show hyperlinks are always changing. So the hyperlink aspect of excel only allows you to define one location per cell and its based on that cell alone and not the verbiage stored inside. So when a hyperlink is defined in a cell it is set, and will not change unless you redefine it.

    Essentially i have 5 cells that will list a file location based on what is searched. I would like those five cells to include the hyperlink location for the particular project files when that particular project is selected. All the pertinent information is stored on 1 sheet organized in a table. I then have a sheet with a search bar that will consolidate the information from the table to where its easier to unpack.

    Is there any solutions to this problem i'm experiencing? Or is this something that is just fixed, based on limitations of excel itself?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Hyperlinks & Vlookups

    Welcome to the forum.

    Not really a hope of anwering accurately without seeing a sample workbook and example of what you are describing.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-25-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Re: Hyperlinks & Vlookups

    I've made a little file that more or less works the way my actual file is laid out. I want the hyperlinks to get carried over to sheet one once called upon, not just the pasted values
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Hyperlinks & Vlookups

    This maybe?

    =HYPERLINK(VLOOKUP(H8,Table1,2,FALSE))

  5. #5
    Registered User
    Join Date
    07-25-2019
    Location
    United States
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Re: Hyperlinks & Vlookups

    Awesome, Thank you so much AliGW. For whatever reason when i tried the =hyperlink() function i was including if() or() statements inside the parenthesis where as i could just include the hyperlink function inside of my if statements. Simple solution, thanks again.

    -im not sure how to mark this as solved~

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlinks - change sheet but not cell reference for multiple hyperlinks at once
    By matt1x1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2018, 05:58 AM
  2. [SOLVED] Range containing many hyperlinks is default blue font -fix to be black but keep hyperlinks
    By RedSummer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2015, 12:01 PM
  3. Excel Hyperlinks in Powerpoint Error - Hyperlinks stripped
    By memsimpson in forum Excel General
    Replies: 0
    Last Post: 05-27-2014, 09:25 AM
  4. Find Hyperlinks, Copy Hyperlinks to alternative sheet, print all hyperlinks
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 05:13 PM
  5. Replies: 7
    Last Post: 06-14-2012, 09:44 AM
  6. Replies: 0
    Last Post: 05-14-2006, 11:45 PM
  7. [SOLVED] vlookups and hyperlinks
    By lmolle in forum Excel General
    Replies: 1
    Last Post: 09-01-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1