+ Reply to Thread
Results 1 to 4 of 4

Hyperlink Vlookup with dynamic text

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    The Hills, Arkansas
    MS-Off Ver
    Excel 2016
    Posts
    69

    Hyperlink Vlookup with dynamic text

    I'm trying to set up a vlookup that displays a hyperlink from Cell A and displays the text from Cell B

    First Attempt: Displays the actual link, verified that it works.
    Please Login or Register  to view this content.
    Second Attempt: Displays link as text from F2, works only on first vlookup of course.
    Please Login or Register  to view this content.
    Third Attempt: This just threw an error.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Hyperlink Vlookup with dynamic text

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-28-2013
    Location
    The Hills, Arkansas
    MS-Off Ver
    Excel 2016
    Posts
    69

    Re: Hyperlink Vlookup with dynamic text

    That worked, Thank you.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Hyperlink Vlookup with dynamic text

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Dynamic Conditional Hyperlink in Text Box
    By RECOChris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2019, 12:21 PM
  2. Replies: 6
    Last Post: 08-07-2018, 08:43 PM
  3. Replies: 1
    Last Post: 08-07-2018, 05:57 AM
  4. Transform entered Text into a clickable Hyperlink via VLOOKUP
    By stonegate in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2016, 08:01 PM
  5. Vlookup value return as Dynamic Hyperlink to another worksheet
    By Ethan1981 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2015, 05:48 AM
  6. VLookUp does returns text, not Hyperlink
    By Matt1985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2015, 01:20 PM
  7. [SOLVED] Copy text and hyperlink using VLOOKUP
    By SeagullWardy in forum Excel General
    Replies: 5
    Last Post: 06-29-2012, 03:24 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