-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hyper links from VLOOKUP
- Thread starter davygryan
- Start date
If you wish to use VLOOKUP to return hyperlinks then this formula works (just input your usual vlookup formula in both sections shown as "..." below.
Code:=HYPERLINK("mailto:"&VLOOKUP(...),VLOOKUP(...))
Hi there thanks for the help.
When I include this formula it opens a new email with the file I am trying to Hyperlink being the "TO" on the email.
Is there any way to link and open the particular file
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Can you give an example of what your VLOOKUP formula returns?
Upvote
0
I'm guessing the hyperlinks you have begin with www.
If so try changin the "mailto:" to "http:\\"
Upvote
0
I'm guessing the hyperlinks you have begin with www.
If so try changin the "mailto:" to "http:\\"
They are actually files that are saved to a local drive.
Is it possible to do this?
Upvote
0
What sort of files are they and what drive are they saved to?
If the links that you are looking up gives the full file name/directory, then use...
=hyperlink(vlookup(...))
Last edited:
Upvote
0
These are pdf files that are saved to our local network drive.
The original Link is on one worksheet (worksheet 2) and I am setting up a search type sheet on another worksheet (worksheet 1). When I put in a name in Worksheet 1 that corresponds to a name in Worksheet 2 it returns all of the associated line items related to that name.
One of these line items is a link that I was hoping would be accessable on Worksheet 1 too
Upvote
0
Similar threads
- Question
