Question Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

2 replies

by paul.ferguson

I am trying to do the exact same thing that you were attempting to do back in September. I have created a combo list that populates according to choice through vlookups. I was curious if you ever found a way to pull the hyperlinks into the document. I have tried to pull in by adding in a hyperlink function but nothing will seem to do what I want.

Any help would be appreciated.

Paul Ferguson
Boral Limited

This discussion is closed to new replies.