Hyperlink HREF question w/ vlookup

[dlotz]

=IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5)," ")

col 5 is a live email address, witht his function I only get text,
Is there a way to have the hyperlink on my main sheet
Pelase asdvsi e

 

[Eduardo]

Hi,

=HYPERLINK(IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5,FALSE)&";")

 

[Eduardo]

OPPs I missed a ), use

=HYPERLINK(IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5,FALSE))&";")

 

[dlotz]

its not working properly,
It look like a link its bold blue and underlined, but when click on the link
it say the file cannot be accessed

 

[Jacob Skaria]

If your formula is working fine try the below..
=HYPERLINK("mailto:" & formula, formula )


Also your formula returns a space incase of error That should be "" instead
of " "

=IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5)," ")


If this post helps click Yes

 

[Jacob Skaria]

=HYPERLINK("mailto:" & IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5),""),
IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500,5),""))

If this post helps click Yes