Offset/Match Formula + HYPERLINK

[PraveshG81]

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 via 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?

This file is located here: http://www.4shared.com/file/_veRsvR9/Conditionality_and_Buyer_Liabi.html

Thanks,
Pravesh

 

[Andrew Poulsom]

That site requires a login. You need to get the URL of the hyperlink, not the friendly text. Sorry, I don't know how to do that with a worksheet formula.