I have a workbook that has 1000+ rows of data. Users need to be able to
reference information quickly using an ID number, so I set up a cell at the
top of the worksheet where they can enter the ID, and using MATCH (in cell
B2) it finds the row number, then I use an INDIRECT to pull the contents of
each column, e.g.

=INDIRECT("A" & B2)
=INDIRECT("B" & B2)
etc.

However, a new column has been added that has hyperlinks to external .doc
and .pdf documents. When I extend the indirect formula over to include the
extra column, it shows the hyperlink text, but is not a hyperlink itself
(e.g. is not clickable).

Is there any way to reference a hyperlinked cell that allows the child
reference to be clickable?

My other option is to add a button and write some VBA to forcibly copy the
link, but I was hoping there is a simpler solution.

Thanks!
Keith