Results 1 to 4 of 4

hyperlink to first match

Threaded View

  1. #1
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Question hyperlink to first match

    quick bit of help if you don't mind

    this is my current code
    =IF($I$4="","",IFERROR(INDEX('PC List'!$A:$G,SMALL(IF(ISNUMBER(SEARCH($I$4,'PC List'!$A$2:$G$417)),ROW('PC List'!$A$2:$G$417)),ROWS(H$6:H6)),MATCH(H$6,'PC List'!$A$1:$G$1,0)),""))
    and have been looking online on ways to have it hyper link to the location on the other sheet. But i havent the first idea where i would plumb in the addiational bits from this site https://exceljet.net/formula/hyperlink-to-first-match

    if you could help that would be great

    cheers and thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match Hyperlink
    By Rompetelo in forum Excel General
    Replies: 1
    Last Post: 05-18-2016, 09:41 AM
  2. Hyperlink to a value from another sheet using match/vlookup
    By CatalinI in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2015, 01:47 PM
  3. [SOLVED] Hyperlink index and match???
    By Matty5894 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-07-2015, 09:50 AM
  4. Hyperlink, Index, Match
    By Bob Lankin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2013, 11:55 PM
  5. Index, match & hyperlink
    By kryzis04 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2013, 09:26 AM
  6. HYPERLINK and MATCH in Macro
    By msf004 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2010, 02:20 PM
  7. Excel 97 Hyperlink using Match
    By debrastus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2008, 09:26 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