Excel VLOOKUP hyperlink to mailto function on different worksheet

A

Akahsa

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,FALSE)). Right now when I
click the link I receive the error: Cannot open specified file.
 

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

Similar Threads

Can I add a formula or function to Vlookup? 1
Vlookup a subtotal 2
Excel 2007: Vlookup Problem 5
Multiply with Vlookup value from another Worksheet 0
Referring to a cell by using another cell for the row number 6
using vlookup and hyperlink 6
Vlookup problem 1
VLOOKUP and MID Function 9

Top