Lookup

[Guest]

I use the following formula to look up information on another worksheet;
=VLOOKUP(B8,Lookup!A1:Lookup!H1203,3,FALSE)

It work well for getting to correct informaion, but the cell on worksheet
"Lookup" also has a hyperlink.

How do I get the formula to also place the hyperlink in the cell?

 

[Tom Ogilvy]

It won't pull back the hyperlink.

 

[David McRitchie]

Hi Mike,
The easiest way would be to add another column to your table
with the hyperlink. You can extract the hyperlink on your Lookup sheet
with a User Defined Function hyperlinkaddress
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinkaddress

On lookup sheet
J1: =personal.xls!hyperlinkaddress(A1)

On your sheet with VLOOKUP -- remove linebreak
=HYPERLINK(VLOOKUP(B8,Lookup!A1:Lookup!J1203,10,FALSE),
VLOOKUP(B8,Lookup!A1:Lookup!J1203,3,FALSE) )

I used column J (column 10) because it is easier to read in response than I1
and you could actually already have something in the 9th column that
you weren't extracting..

 

[Guest]

Is there something that will pull the hyperlink and the value?