vlookups and hyperlinks


M

michaelsaxon

Hi, I am a conservation biologist working in Australia and unfortunatel
I do not have a comprehensive knowledge of excel. I am in the proces
of creating a series of workbooks each of which contain lists of
large number of vegetation types which occur in particular geographi
regions. Currently I am manually inserting hyperlinks from each typ
to a detailed description of that type (which are all held on
separate worksheet in the workbook). I have been attempting t
automate this somewhat by using vlookup to reference to a list o
hyperlinks. However rather than returning a hyperlink reference, th
vlookup returns the text (without the link). Is there anyway of usin
vlookup to replicate the hyperlink (or any formula rather than th
result for that matter).

I would appreciate any advice
 
Ad

Advertisements

D

Dick Kusleika

Michael

You may be able to use the HYPERLINK function to replicate that. It would
look like this

=HYPERLINK(VLOOKUP(...))

It may not be quite that easy, depending on what your VLOOKUP actually
returns. If it doesn't work, post back with more details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top