+ Reply to Thread
Results 1 to 3 of 3

Preserving URL with VLOOKUP where text doesn't match URL

  1. #1
    Registered User
    Join Date
    12-18-2008
    Location
    California
    Posts
    5

    Preserving URL with VLOOKUP where text doesn't match URL

    I am attempting to use VLOOKUP to bring over data from another worksheet along with the URL attached to the text.

    I tried using the following and it doesn't bring over the url but only the text data which is different from the url.

    =HYPERLINK(VLOOKUP(L2,SharepointPhotos!A2:B7014,2,FALSE))

    Worksheet 1- AllPhotos
    This worksheet is where I am trying to bring over data from SharepointPhotos with a match from column L2 of this worksheet.

    Worksheet 1- SharepointPhotos
    This worksheet contains the data I would like to bring over to the AllPhotos worksheet. Column A contains what I am matching to L2 of AllPhotos and Column B is what contains the data I need to bring over.

    I have also tried adding the following to the standard module along with the following code but it still doesn't work.

    Function GetHyperLink(r As Range) As String
    If r.Hyperlinks.Count Then
    GetHyperLink = r.Hyperlinks(1).Address
    End If
    End Function

    =HYPERLINK(GetHyperLink(INDEX(SharepointPhotos!$B$1:$B$7014,MATCH(L2,SharepointPhotos!$A$1:$A$7014,0))),(VLOOKUP(L2,SharepointPhotos!$A$1:$B$7014,2,FALSE)))

    Any suggestions or help would be greatly appreciated.

    Thanks.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Preserving URL with VLOOKUP where text doesn't match URL

    I developed this piece of code for use in a different program. I have Topics in the "Link_list" named range and the hyperlink text in the cell to the right. The syntax of assigning the link may be of help to you.

    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    12-18-2008
    Location
    California
    Posts
    5

    Re: Preserving URL with VLOOKUP where text doesn't match URL

    Thanks for the info. I will attempt to modify the 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. Replies: 1
    Last Post: 11-25-2021, 07:21 AM
  2. Excluding a countif if text doesn't match
    By solrax560 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2019, 01:59 PM
  3. Return cell if vlookup doesn't find match
    By mhkeim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2019, 12:26 PM
  4. Index + Match doesn't work with text
    By blueturnaround in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2014, 01:18 PM
  5. [SOLVED] Vlookup function doesn't work on identical text
    By moty.98 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-17-2013, 11:35 AM
  6. Replies: 0
    Last Post: 10-20-2011, 12:33 PM
  7. Replies: 1
    Last Post: 05-04-2005, 02:15 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