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.