+ Reply to Thread
Results 1 to 3 of 3

Vlookup to Display Hyperlink

  1. #1
    Registered User
    Join Date
    08-03-2011
    Location
    Anytown, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Vlookup to Display Hyperlink

    I will try to explain this as best I can.. I have a workbook with a worksheet filled with hyperlinks; (Formulas sheet). I have a second sheet (Triage PCN's PDN's) that has countless hyperlink functions referencing the Formulas sheet. I now have a third sheet (Search) using vlookup functions to display information from Triage PCN's PDN's, related to information I type into a cell (M3) on the Search sheet. This all works great, but the information being displayed on the Search sheet does not include hyperlinks, just text. I would like it to include the hyperlinks. Is it possible to do this without using script? I am trying to avoid people having to click enable macros, as this will be used by hundreds of people, and some are bound to click disable macros. Any help is appreciated. Thanks.

    Here are some example formulas:
    =HYPERLINK(Formulas!B2, "Yes") - Example from Triage PCN's PDN's sheet

    =IF(M3="", "Type in the PCN and hit enter",IF(ISNA(VLOOKUP(M3,'Triage PCN''s PDN''s'!A2:E1600,4,FALSE)),"No Results Found",VLOOKUP(M3,'Triage PCN''s PDN''s'!A2:E1600,4,FALSE))) - Example from Search sheet

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Vlookup to Display Hyperlink

    Hey Mjilek;

    Could you post a sample workbook? Just a small subsection of the data to highlight the problem, with any personal or confidential information removed/scrambled.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  3. #3
    Registered User
    Join Date
    08-03-2011
    Location
    Anytown, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Vlookup to Display Hyperlink

    Sure, here is a sample of what I'm working with ..Sample SS.xls
    I am trying to get the hyperlink that the formula from the 2nd sheet comes up with, to show up in the first sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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