i'am trying to create a database which has all the information i need in sheet 2 and a cover sheet in sheet 1.

i have used V look up so that when i type in a location in a table on the cover sheet, all the information i need is brought from sheet 2 into the table.

the problem i have is that i have hyperlinked text in sheet 2 which takes me to a document, but in the cover sheet when i type in the location the text comes up but no hyperlink

does anyone know how to v look up a hyperlink?