How to Retain Hyperlinks on Search Page?

[Shawna11]

Hello,

My first sheet titled "Search" contains search boxes at the top and columns/rows below with the searchable data. The columns/rows below automatically populate the related data as you type in the search boxes, showing you only related results. This information is taken from my Sheet #2 "RawData".

My problem is that I would like the "Link Name" column on the "Search" sheet to contain a hyperlink to its related PDF document on my shared drive. I can create the link to the document, but as soon as someone does a search, the hyperlink does not show up until you clear the search fields. I would like the link to stay active and be clickable at all times. Is this possible? even if i make the data a hyperlink on my "RawData" sheet, it does not carry over to my "Search" sheet.

I'm using this formula on the "Search" sheet cells: =IFERROR(INDEX(RawData!$B$5:RawData!$I$2000,RawData!$L5,COLUMNS($B$16:B16)),"")

example 1.JPG

example 2.JPG

[CK76]

Please upload sample file (with desensitized data).

To upload file, in quick reply menu, click on "Go Advanced" and then locate "Manage Attachment" link. Click and it will launch new tab to attach document(s).

Without knowing "how" your links are generated in the first place. It's difficult to give you solution.

In general, without using VBA it's not possible to bring over link from another cell (or copy paste).

For Excel 2010, there is only one way that I am aware of.

Use helper column in source that contain full link source address (or have full path to file as hyperlink text). Then use Hyperlink() to reconstruct link in your "Search" sheet.