+ Reply to Thread
Results 1 to 1 of 1

Adding Hyperlink formula to existing formula

  1. #1
    Registered User
    Join Date
    01-17-2018
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    2

    Question Adding Hyperlink formula to existing formula

    Hello all,

    I was wondering if someone could help me understand if it is possible to add a HYPERLINK formula into my existing formula below. Currently the below formula pulls information from my "RawData" sheet and automatically duplicates it onto my "Search" sheet to reflect the RawData sheet's information, even when it it edited. However, i need my "Search" sheet, starting from Cell "I16" and down that column to not only stay linked with the rows from the "RawData" but to also be a hyperlinked to individual PDF. documents.

    =IFERROR(INDEX(RawData!$B$5:RawData!$I$2000,RawData!$L5,COLUMNS($B$16:I16)),"")


    Really i don't need the "Link Name" column on my "Search" sheet to contain any inforamtion other than a hyperlink to my document; however, i do need it to stay connected to the other 7 columns when they move as information is searched.

    Example of my Workbook "Search" sheet below, which includes a dynamic search filters which change the results as you type (attachment of excel below):

    example 1.JPG

    example 2.JPG
    Attached Files Attached Files

+ 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. Adding a Date Formula to existing formula
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2016, 08:21 PM
  2. Replies: 3
    Last Post: 01-13-2016, 12:05 PM
  3. adding to existing formula
    By jryoung91 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2015, 09:39 AM
  4. [SOLVED] Adding a date formula to an existing formula
    By amasson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-18-2014, 04:20 PM
  5. adding to existing formula
    By wwoody in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2013, 03:25 AM
  6. Adding to 2 existing formula
    By cmackay1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2012, 05:14 PM
  7. [SOLVED] Adding a match formula to an existing formula
    By pauldaddyadams in forum Excel General
    Replies: 8
    Last Post: 08-16-2012, 05:14 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