| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink HREF question w/ vlookup
=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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink HREF question w/ vlookup
Hi,
=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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink HREF question w/ vlookup
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink HREF question w/ vlookup
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 " wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink HREF question w/ vlookup
=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 --------------- Jacob Skaria "Jacob Skaria" wrote: 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 " wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink Question | Excel Discussion (Misc queries) | |||
| hyperlink question | Excel Discussion (Misc queries) | |||
| Hyperlink Question | Excel Discussion (Misc queries) | |||
| hyperlink question | Excel Worksheet Functions | |||
| Hyperlink Question | Excel Discussion (Misc queries) | |||
Linear Mode
