+ Reply to Thread
Results 1 to 4 of 4

Vlookup hyperlink

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    England
    MS-Off Ver
    2010
    Posts
    15

    Post Vlookup hyperlink

    Hi guys,

    I am trying to do a Vlookup for a hyperlink.

    "=HYPERLINK(VLOOKUP(A2,Sheet2!A1:B5448,2,FALSE))"

    However, once I press the link I get an error message saying:

    "The adress of this site is not valid. Check the address and try again."

    Could someone be nice and help me find a way to solve this problem?

    I have uploaded the file!

    Thanks in advance,

    Hewe
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Vlookup hyperlink

    You can't have a HYPERLINK reference another hyperlink. Your formula returns "Click Me" because that is the displayed text of the referenced cell.
    On Sheet2 of your file, Col_B should be the link address.

    Perhaps, Col_C could contain the text you want displayed in the hyperlink.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    07-11-2014
    Location
    England
    MS-Off Ver
    2010
    Posts
    15

    Re: Vlookup hyperlink

    I have now converted it to URLs but now it gives the error of "Cannot open the specified file"
    Last edited by itshewe; 07-26-2014 at 10:15 PM.

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Vlookup hyperlink

    I'm guessing you didn't include the "http://" in the referenced URL.
    Try this formula:
    Please Login or Register  to view this content.
    Does that help?

+ 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. Replies: 6
    Last Post: 09-05-2022, 12:27 AM
  2. 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
  3. Replies: 4
    Last Post: 03-07-2012, 07:06 AM
  4. Hyperlink + Vlookup + If
    By phoztek in forum Excel General
    Replies: 3
    Last Post: 09-05-2009, 08:54 AM
  5. Hyperlink & Vlookup
    By monkeydogger in forum Excel General
    Replies: 4
    Last Post: 01-22-2007, 01:05 PM

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