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?

It won't pull back the hyperlink.

--
Regards,
Tom Ogilvy

"Mike" wrote in message
...
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?

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...perlinkaddress

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

On your sheet with VLOOKUP -- remove linebreak
=HYPERLINK(VLOOKUP(B8,Lookup!A1:Lookup!J1203,10,FA LSE),
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..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mike" wrote in message ...
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?

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

"Tom Ogilvy" wrote:

It won't pull back the hyperlink.

--
Regards,
Tom Ogilvy

"Mike" wrote in message
...
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?