+ Reply to Thread
Results 1 to 2 of 2

VLookUp does returns text, not Hyperlink

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    9

    VLookUp does returns text, not Hyperlink

    Hi,

    I have a vlookup pointing at cells which have a hyperlink to a website. The hyperlinks are 'hidden', and the cells only show the "text to display", and not the links.

    So my vlookup returns the text rather than the links themselves.

    How can my vlookup return the actual links?

    =HYPERLINK(VLOOKUP(B21,Links!E:H,4,0))

    Thanks
    M

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: VLookUp does returns text, not Hyperlink

    Take a look at this and see if it can help you out:

    http://www.ozgrid.com/forum/showthread.php?t=25806

    Hope this helps!
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. Replies: 0
    Last Post: 04-14-2014, 05:31 AM
  3. 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
  4. [SOLVED] Copy text and hyperlink using VLOOKUP
    By SeagullWardy in forum Excel General
    Replies: 5
    Last Post: 06-29-2012, 03:24 AM
  5. Replies: 4
    Last Post: 03-07-2012, 07:06 AM

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