+ Reply to Thread
Results 1 to 2 of 2

Hyperlink does not transfer with INDEX function

  1. #1
    Registered User
    Join Date
    10-04-2018
    Location
    Connecticut, USA
    MS-Off Ver
    2016
    Posts
    1

    Unhappy Hyperlink does not transfer with INDEX function

    Hi everyone,
    I'm working on a neat little searchable database at work. I have all of the leg work done but I ran into a snag when trying to get hyperlink to transfer properly using the index function. The basic problem is that at work there's a database of over 200 defined Lat/Long boxes that I wanted to make searchable based on a given Lat/Long point. So I did some basic conversions and some if and statements to determine if a box had that point inside of it. Then using the INDEX function searched for those instances and display the data that matched. As stated previously this works great until hit the hyperlinks.
    I've tried doing hyperlinks 2 different ways (HYPERLINK= and right click and assign hyperlink) but neither seems to work as you can see in the sheet. So my questions are:
    1) Is there a way to get the link to transfer properly with the INDEX function?
    2) If not, is there another function that will do this properly?
    3) Is this just a limitation of Excel and I need to find some other approach?
    Thanks in advanced,
    Nate
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,905

    Re: Hyperlink does not transfer with INDEX function

    Hi, welcome to the forum

    1. Your formula could be shortened to this...
    =IFERROR(INDEX(Database!$A:$N,SMALL(IF(Database!$A$2:$N$6="Y",ROW(Database!$A$2:$A$6)),ROWS($A$1:A1)),2),"")

    2. No (added) formatting will be pulled across with a formula (except time and $), so you would need to create the HL IN the formula itself.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Transfer hyperlink in autofill columns
    By dmeredith in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2016, 11:54 AM
  2. VBA transfer data from excel to word by clicking a hyperlink
    By kregg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2013, 01:43 PM
  3. [SOLVED] Use hyperlink to transfer data from a specific row to another sheet.
    By chriswhite1982 in forum Excel General
    Replies: 4
    Last Post: 05-29-2013, 06:23 AM
  4. [SOLVED] Hyperlink transfer to PDF
    By kissmydrone in forum Excel General
    Replies: 2
    Last Post: 11-10-2012, 04:02 PM
  5. Transfer Data To Another Worksheet And Create Hyperlink
    By jasono in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2011, 06:42 PM
  6. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  7. [SOLVED] How to transfer email hyperlink to another cell
    By Peepster in forum Excel General
    Replies: 2
    Last Post: 03-29-2005, 05:06 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