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