Hyperlink & Vlookup

**monkeydogger** · 01-19-2007, 12:07 PM

Hello all, this is my first post and hopefully some kind soul will be able to help me.

I am currently using this formula to return a value from a cell.

=(VLOOKUP(A1,'Table 1'!A1:C143,2,FALSE))

In the referenced worksheet column, the cell contains a hyperlink to a document on a network drive as well as a value. Is there a way of copying the value and the hyperlink to the display page?

Thank you in advance.

Edit:-- I have also tried the =Hyperlink(VLOOKUP(A1,'Table 1'!A1:C143,2,FALSE))

**Carim** · 01-19-2007, 12:33 PM

Hi,

In Table1, you could add column D with the following function

Please Login or Register  to view this content.

**monkeydogger** · 01-22-2007, 04:34 AM

Thanks Carim, will give it a spin and let you know how it goes.

**monkeydogger** · 01-22-2007, 05:03 AM

Just as an afterthought, would it be possible to use the hyperlink function to copy the hyperlink from column D but display the information from column B?

Just an alternative route to the same goal.