+ Reply to Thread
Results 1 to 5 of 5

Broken Hyperlink When Using Vlookup

  1. #1
    Registered User
    Join Date
    08-11-2014
    Location
    Istanbul, Turkey
    MS-Off Ver
    2010
    Posts
    3

    Broken Hyperlink When Using Vlookup

    Hello everyone
    I've been trying something on excel and I've been searching for a long time. I can't find any solution.
    So I have a problem that I want vlookup to my hyperlinks and my hyperlinks are attached another sheet on the same file. When I use =HYPERLINK(VLOOKUP(A2;Sheet2!$A$2:$B$5;2;0)) formula I get an error 'The address of this site is not valid. Check the address and try again.' But I already don't use an 'website link'.
    I have attached the Excel file as an example of what I'm trying to do. Your help is much appreciated.
    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Broken Hyperlink When Using Vlookup

    you need # if its in the same workbook
    =HYPERLINK("#'"&VLOOKUP(A2,Sheet2!$A$2:$B$5,2,0))
    on the other hand why do you need to look it up?
    =HYPERLINK("#'"&A2&"1'!a1")
    Last edited by martindwilson; 08-11-2014 at 11:01 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    08-11-2014
    Location
    Istanbul, Turkey
    MS-Off Ver
    2010
    Posts
    3

    Re: Broken Hyperlink When Using Vlookup

    Thank you for your help, I'm appreciated.
    But now I have another problem. Excel file was OK, then I saved it and I quit. Now my hyperlinks don't work. I get 'The name you entered is not valid' error.
    Can you also help me about that?
    Regards

  4. #4
    Registered User
    Join Date
    08-11-2014
    Location
    Istanbul, Turkey
    MS-Off Ver
    2010
    Posts
    3

    Re: Broken Hyperlink When Using Vlookup

    It is the original file. I don't know where is the problem?
    Attached Files Attached Files

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Broken Hyperlink When Using Vlookup

    you are trying to link to hyperlinks but the info returned from the second sheet is the friendly hyperlink name not the underlying hyperlink do it like this
    Attached Files Attached Files

+ 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. [SOLVED] Broken ROUUNDUP or VLOOKUP formula
    By macrorookie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-05-2014, 08:49 AM
  2. The broken Hyperlink
    By ScoGeosan in forum Excel General
    Replies: 2
    Last Post: 01-17-2014, 10:26 AM
  3. Broken Formula to Hyperlink longitude and latitude cells to google maps
    By Nola ADA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 09:48 AM
  4. Using Vlookup to pull hyperlink from Master Hyperlink file list.
    By theflyingnimbus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-02-2013, 01:42 PM
  5. Replies: 1
    Last Post: 09-15-2005, 03:05 PM

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