ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel VLOOKUP hyperlink to mailto function on different worksheet (https://www.excelbanter.com/excel-worksheet-functions/251235-excel-vlookup-hyperlink-mailto-function-different-worksheet.html)

Akahsa

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.


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com