Results 1 to 4 of 4

Thread: Offset/Match Formula + HYPERLINK

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Offset/Match Formula + HYPERLINK

    Hello,

    I need some help carrying over hyperlink from one sheet to another. I basically use an internal program to export data to my raw tab. One of of the fields that I export is the "Acquisition Agreement". This field brings in the hyperlink to get to a document stored in our internal document management service (for security purposes i have removed the DMS link and put links to yahoo or google). On the Results tab I am using a Offset/Match formula to bring in columns from the Raw tab.

    I need help with Column B (Acquisition Agreement) in the Results tab. As you can tell from the attached spreadsheet i have add a hyperlink component to my formula BUT when i go and click on any cell that has content in Column B I get the following error: (Cannot open the specified file). However, when i go to the same link in the Raw tab it works.

    Could someone please tell me how i can fix this issue?

    Thanks!
    Pravesh
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •