Hyperlink access with lookup fuction

[dgregg]

Good morning everyone, I am looking for a little help with getting a hyperlink to work. I am attempting to use V & H look up functions to provide me a hyperlink to another worksheet that is contained inside the same workbook. I can get the look up function to work just fine, I am having trouble getting the hyperlink that appears in the cell to work. The hyperlink works just fine from the original list, which is saved on a separate worksheet. Any thoughts? I assume this is some kind of formatting error that I am missing.

 

[dgregg]

Any help with this would be great.

 

[Mohammed Yusuf]

Hi,

lookup doesn't work in hyperlink formula values so copy that hyperlink values to another sheet & while pasting paste that value in " plain text format or values only " & set lookup search key format as plain then set vlookup & hlookup in this copied values..........values will be return successfully... i'm already using this way to lookup on hyperlink values

 

[dgregg]

Thanks for the help, I can get it to return the value for the hyperlink, but am unable to return the actual working hyperlink. Is that even possible?

I am attempting to make a WB comprised of about 150 WS. From the home WS I would like to have two drop down lists that I can select a value, that will then determine what values populate drop down list #2 , then from my selection in drop down list #2 a hyperlink will appear that I can select to go to one of the other WS. So just returning the hyperlink value is not the desired outcome. I would like that link to be functional.