| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel VLOOKUP hyperlink to mailto function on different worksheet
I am trying to use VLOOKUP to pull email addresses from another worksheet
that are a functioning link to outlook. The links work on the original sheet but not through the VLOOKUP. Here is the formula I am using, any help would be greatly apprecieted. =HYPERLINK(VLOOKUP(A2,Processors!$A$1:$B$50,2,FALS E)). Right now when I click the link I receive the error: Cannot open specified file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a hyperlink in a mailto: to a new cell in Excell? | Excel Discussion (Misc queries) | |||
| Hyperlink mailto - ref cell for mail subject | Excel Worksheet Functions | |||
| =HYPERLINK("mailto: | Excel Discussion (Misc queries) | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
| Add mailto (email) as function to a button in excel | Excel Worksheet Functions | |||
Hybrid Mode
