gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I would like to have cell A1 in DATA do a vlookup over to ECRMDATA and find and recognize a hyperlinked cell that goes to a redirected website....
Every time I try to follow all suggestions I get the "cannot open the specified file" error but if I go to ECRMDATA sheet and click on the hyperlink it takes me to the redirected website correctly.
Here is my formula in cell A1 of the DATA sheet.
=HYPERLINK(VLOOKUP(DATA!$AO$3&'AD CODING'!$B3&'AD CODING'!C3,ECRMDATA!$A$2:$AW$8500,5,0))
DATA cell A! result is :Front (1) which is what is the vlookup result from column % of the ECRMDATA sheet has the hyperlink that will launch successfully to the redirected website.
Here is the URL that is hyperlinked into the ECRMDATA sheet cell that I am trying to lookup:
ECRM® Data
Any help would be greatly appreciated.
Every time I try to follow all suggestions I get the "cannot open the specified file" error but if I go to ECRMDATA sheet and click on the hyperlink it takes me to the redirected website correctly.
Here is my formula in cell A1 of the DATA sheet.
=HYPERLINK(VLOOKUP(DATA!$AO$3&'AD CODING'!$B3&'AD CODING'!C3,ECRMDATA!$A$2:$AW$8500,5,0))
DATA cell A! result is :Front (1) which is what is the vlookup result from column % of the ECRMDATA sheet has the hyperlink that will launch successfully to the redirected website.
Here is the URL that is hyperlinked into the ECRMDATA sheet cell that I am trying to lookup:
ECRM® Data
Any help would be greatly appreciated.