How to transfer a hyperlink from the cell a lookup formula locates in Excel

I have a database in worksheet 2 in a Excel 2007 workbook. In worksheet 1, I have a combo box that lists the project numbers listed in the worksheet 2 database. As a person selects a project, several other cells in worksheet 1 are populated with the data, associated with that project number, from the database worksheet. The problem I am running into is that some of the cell in the database are hyperlinks, but when the lookup formula displays the data within the cells in the database, the hyperlink is not present. How can I fix this?
THANKS TO ANYONE WHO ANSWERS!