Hyperlink HREF question w/ vlookup
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
"Eduardo" wrote:
OPPs I missed a ), use
=HYPERLINK(IFERROR(VLOOKUP(U2,agt_ary!$A$1:$E$500, 5,FALSE))&";")
" wrote:
=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
|