Excel: Hyperlink format

[mkrets]

I have a table of values that I'm using for a vlookup on another sheet. One of the fields in the table is a field containing a hyperlink to a pertinent page for the record on our intranet.

My problem is that when I vlookup the value, it doesn't retain it's format as a hyperlink and I can't figure out how to regenerate the hyperlink using the link that the vlookup returns.

Any ideas?

 

[SkipVought]

Hi,

Put the hyperlink in the cell adjacent to the lookup value so they are BOTH visible.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[mkrets]

I guess I don't understand what you are saying. I am looking up the address that the hyperlink should point to. When I use the look up it returns the URL I want but not in hyperlink format so a user can click on it.

 

[SkipVought]

You will either have to navigate to the hyperlink cell in order to activat the link or write VBA code to accomplish what those steps would do.

If you wish to pursue a code solution, please post your question in Forum707.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[yogia]

I guess I don't understand what you are saying. I am looking up the address that the hyperlink should point to. When I use the look up it returns the URL I want but not in hyperlink format so a user can click on it.

Hi mkrets:

How about wrapping your VLOOKUP formulation in the HYPERLINK function as in ...

=HYPERLINK(VLOOKUP(...))

Let me know how it goes and then let us take it from there.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com